We stayed at sites 81 and 95. Site 95 was waterfront, no shade, and real close to a rocky beach swimming area. Around the corner was a sandy beach buoyed swimming area. There are a lot of good shady sites but none on the water. There are deer everywhere in the park and will almost eat from your hand. Nice level blacktop sites.
We stayed at Camper Village in the newer section with full hook ups. We stayed 3 nights at the first of June. It is expensive $66 a night with full hookups, but worth it for the convenience. Cedar Point is pretty isolated from the town of Sandusky it takes a good 30 minutes to get off the island, go into town and find something to eat or a grocery store and the same to get back so forget about leaving for lunch unless you want to lose 1-2 hours. It is a well landscaped, clean campground. Every site has their own trash can emptied daily; they clean your ashes out of your grill daily if you BBQ. The best part of it for us was the ability to get up eat breakfast, walk into the entrance an hour early before park opens to the general public, get the big rides out of the way before it gets crowded, then go back to trailer eat lunch, then change into swimming attire and go to the water park which is even closer maybe 100 yds, the water park is really nice and all of it is heated alot. I wasn't expecting warm water in early June. Then after several hours go back to the trailer eat dinner, change clothes, and go back to Cedar Point for the remainder of the evening. Between the money I saved for meals for 5 of us at the park, and the daily parking fee of $10 that I would have had to pay if I stayed elsewhere, and the convenience it was well worth it to me, especially if you get the 2 Day Ride and Slide like we did.