My husband and I, along with our dog Frank, found site P27 using Google Maps Satellite view and saw that it was juuuuust far enough away from the RVs to feel like we were camping in the woods.
The site itself doesn't allow you to have a vehicle at site and the short wooded trail to the site does get incredibly muddy when it rains heavily. However, your vehicle is close enough but you can't see it easily due to the wooded area between the site and the rest of the campground/parking lots. I felt that aspect made this site all the better. HOWEVER, you will be carrying your firewood into the site if you buy it at the campsite store so keep that in mind depending on your physical abilities. P27 wouldn't be very convenient for strollers and definitely not wheelchair friendly unfortunately.
The site itself is mostly rock and gravel as you look towards the lake with the rear portion of the site turning to the wooded area. There is decent enough shade for your tent and a friends tent if you're using 1 to 4 person set ups... but the tents will be CLOSE.
There isn't a great hammock set up option at this site. We had two with us and could only hang one, the trees were fairly young and on the edge of a small drop off to the rocky beach. That was a decent spot to hang a hammock but a double with adults would be detrimental to the trees perhaps.
There is a picnic bench that is staked to the rock with a chain so you have limited options of moving that closer to the fire pit or further away. Table was in great shape.
The bath house was super nice but a bit of a walk from this site. Toddlers wouldn't be stoked on it more than likely.
We visited Halloween weekend and there was a huge thunderstorm for the majority of the two nights we spent here. The site got incredibly muddy by the fire pit, like... boots sticking in the mud wet Ky clay.
All that aside, we will be camping here. The RV section was packed and they had trick or treating for the kids but we couldn't hear any of it from this site. Waking up in the morning to the fog on the lake was super beautiful. Watching people fish from their boats Sunday morning and walking the shoreline looking for cool rocks... it's a great campsite. It's an awesome tent site and everyone that worked at the campground was great. A young man came to check on us because of the thunderstorm as well.
*tent stakes work just fine at this site. It's not just a rock outcropping.