Towards the end of the video it looks like you go into site #7 and then it does a video transition to the shore of the lake. Is that an exclusive bit of shoreline available to site #7? Or is that by the main 'boat launch' area? Are there any other campsites with their own 'private' access to the lake, right from the site?
If I remember right that's a common path to the lake between a couple campsites. But there are a number of sites where you can get to the lake. Plus there's a trail leaving the south side of the campground (to the right as you face the lake) that goes around the whole lake where you can find lots of quiet spots. Weekdays in September things get quieter there, and most of the mosquitoes are gone.
Empty Campgrounds can be.... creepy so I guess it is fitting for the video :) I think the original intentions were calming but I can see how it would be creepy too.