Raining? Stay away.
We got a site here after our reservation expired at the Tourist Park. (I had all intentions of getting into one of the pictured rock drive in sites...needless to say that was a failure on my part.) And we arrived here and reserved a spot during a torrential downpour. We drive to our spot to set up...and the entire...I mean ENTIRE campsite was flooded, with no chance of us setting up. It wasn't just our site, multiple sites were completely flooded out. I went back to the desk and told them the problem. They told us we could set up on their front lawn instead. You know, right by the road. Neat. I agreed and since we were hangry we got food and waited for the rain to stop. We came back a few hours later and miraculously the puddles disappeared. Yay. We set up, and hoped the storms were over, because if they happened again we would have had flooded tents. Not for lack of good products, but for lack of drainage/height. The water was that deep. As for noise, once again in Munising I had to get up at 1am to tell some loud, drunk @ss 5th wheel neighbors a couple sites down to STFU.
Also, for what it's worth, we had little to no choice of campgrounds during this trip. Everything was booked. (again, I thought we would find a site within Pictured rocks. Whoops.) Otherwise we would have left after seeing the drainage problems.