It has been a very long time since I have seen a truly "spectacular" fireworks display in person. Comes with living in a smaller town, and not going anywhere, very often.
Normally, the biggest wow-factor for me is when whomever put on the show were able to use some of those giant "double shells" that blow and become a cascade, and then there's a secondary effect that's completely different. Those are the big shells that are 10-12" in diameter and cost $500+ EACH... yikes. But spectacular, to be sure!
I also live in a smaller town, but the sheer amount of wineries and breweries that have popped up all around us has changed the pace of life a little around here, tourism has grown exponentially- there are of course downsides to this, but one of the upsides is a spectacular fireworks show, haha!
I can't even imagine what they spent on that, but considering how many people were there buying wine, they probably made out okay :)