Good afternoon from Marquette, Michigan!
One of the challenges is that many of our local campgrounds will stop taking reservations as of Oct. 1, but may stay open on a first-come, first-serve basis until the forecast calls for our first real freeze.
Are you planning to stay on the Lake Michigan coast, or do you want to come the extra 60 miles North to Lake Superior?
The area around Munising usually peaks for fall color around October 10, so your timing will be perfect. There are a lot of small, unimproved, rustic campsites South of Munising off H-13, but you'd be hard-pressed to get your coach in to most of them. Nonetheless, those inland lakes are some of the best places to see the fall color. Bring a camera and make sure you catch a few sunrises with the mist and reflections!
Since I'm on Superior, here are a few campgrounds that should be open through the time you'll be here:
Woodland Park in Grand Marais, MI (On the Northeast end of the Pictured Rocks and the most scenic little Lake Superior town you'll ever visit. The park doesn't take reservations and is first-come, first-serve. They also close no later than late Oct., sometimes earlier if freezing weather sets in sooner. Don't bank on this place, but it's a great option if everything works out!)
Munising Tourist Park (gateway to the Pictured Rocks National Lakeshore and a great place to stay right on the shores of Lake Superior.)
Rippling River Resort (right on the Carp River, just a few minutes from Marquette and Lake Superior, open year-round, and brand new. They're also within walking distance to the ski hill, the Mount Marquette scenic overlook, and the NTN South Trails mountain bike and hiking trail network.)
Gitche Gumee RV Park (close to Marquette, right across the highway from Lake Superior, and open year-round)