When we lived in GA, we could see the "trail" when the shuttle took off. Was too cool! Once when they had a night take off, we could see it glowing in the sky.
I've always wanted to go and watch one happen. We have some friends that work at NASA and they've said that when ever we want, we can come visit and we can go to where you can see it up close and personal.