When I lived in Vermont, the Waterfront in Burlington was the prime location to see a fireworks show. They would be set off on the barge in the lake. It was awesome, wicked crowed but awesome!
I think watching fireworks is my favorite thing to do on the 4th. Turns me into a kid every year.
Enjoy!