Yeah, I went twice as part of a summer internship exchange thing. The first time they scrapped the launch. The second time, it went up.
Sitting in the sun for a few hours, steam, rumbling, seeing the shuttle through binoculars. It's very similar to what you see on the TV except for the sitting in the sun until they scrap the launch, sitting in the sun until they do launch, and feeling the rumble go through your body.
The tour through the visitor complex stuff is more interesting than seeing the launch.