We're lucky here in Montreal. There is an international fireworks *competition* that is held on the St-Lawrence River adjacent to the impressive looking, teardrop style, Jacque Cartier bridge.
So we're kinda spoiled with fireworks.
The official website isn't working, but this guy has an impressive site with lot's of pictures from different competitions.
http://www.montreal-fireworks.com/