Given all of the positive reviews of Fremont Street, I am providing this review as a public service.
With a slight twinge of reluctance, I am giving a "Terrible" rating to the Fremont Street experience. First, the reasons to go: (1) this is where Vegas started, (2) the casino lights (which you've likely seen before on tv) are kind of cool, and (3) you can dance in the streets to live (cover) bands, if you're into that. There is no other reason to go, and there are many other, better things to do in Vegas. Plus, it's an hour bus ride to and from Fremont Street and the Strip.
One of my travel companions highly recommended the light show. We saw the show, and then we wondered what the fuss was about. The light show is simply a humongous screen that covers the street like a canopy. When it finally came on, the casino lights shut off, which I expected to be neat, but it really wasn't particularly amazing. The show itself was just a video of (clothed) dancing girls, like you'd see in a music video. I would not bring kids here (at least, not at night--not sure about the day). There was a giant video screen with girls taking their tops off, with a censor bar (which said stuff like "shazam!!!" and "whoa!!!" covering their naughty bits). Classy. There were also plenty of strip clubs. The casinos were all very smokey. I had been told that there were lots of shops to explore there, but they were just the same old souvenier shops that you'd find anywhere in Vegas.
If you are interested in the history of Las Vegas and/or really want to see it all, then I'd recommend coming here. Otherwise, I'd avoid it.
This review is the subjective opinion of a TripAdvisor member and not of TripAdvisor LLC