I'm sure you are aware of it but St. Cloud puts on a good show. If u can find your way around on the Mississippi and park your boat between Hester and Wilson Parks that would be a great view.
Another one in the area is the Annandale fireworks. Find your way onto Pleasand Lake next to town and park out about 100 yards from the south shore and you will see a good show as well. And with the added benefit of a fish bowl lake and no obstacles to ding your lower unit in the dark finding your way back to the public access. They have always had a carnavil atmosphere around as well with food, rides, and the Crowning of the Queen of the Lakes that night just off the lake too.