Since reservations were hard to come by closer to Pictured Rocks- busy weekend in Sept!  We stayed here our first night.  I am not a huge fun of campgrounds of this type- with smaller, less secluded sites, but in a bind it worked out well.  Good facilities and near Tannery Falls which was a nice little hike to a large waterfall.  Large number of sites, we will opt for the rustic tent/walk-in sites next time since they seemed to be more secluded. 

Some sites very near the water- I would think these are a good choice! We arrived late, so had minimal options.

*visit Tannery Falls- Not a ton of water flowing, but very rustic and relaxed place! We didn't see anyone else for most of our time there :)   Also near is Munising falls- easy access to a nice waterfall and Miners Falls another pretty easy to access falls.