first at the hub in front of castle...I felt "too close"
second was on Main street bridge...much better as you get a wider view and can appreciate all of the fireworks...you can hear the music great from just about everywhere...piped in all over
The best place I've seen it is on the walkway between the tip board and Crystal Palace. If you get a spot at the rail, there's no way anyone can stand in front of you (there's a little hill going down to a pond), so it's a great unobstructed view.