We will also be at Alumapalooza. I will look for your dog and introduce myself!
Our favorite campgrounds in Michigan
Lake Fanny Hooe in Copper Harbor (next to Fort Wilkins state park)
In Houghton/Hancock, the city of Hancock has a nice municipal campground
In Sault Ste. Marie (Michigan side), Aune-Osborn Campground. It is so close to the locks that when the ships go by it is like watching a building float by silently. Nice July 4th fireworks too
In Ohio, Maumee Bay State Park outside of Toledo we have enjoyed.
This is all I can recommend from personal experience. Enjoy your first season with your Airstream!