We've seen two launches both daytime. The first from the car park of our hotel on International Drive and the second by Crystal Palace in Magic Kingdom. On both occassions it was a great experience.
I'm sure the atmosphere is fantastic from KSC, but be warned as launches can be cancelled at a moments notice, so you could lose out a day/days of your holiday chasing one.