I have stayed here and and Davidson River in Brevard. There is also Mill River between the two but am not familiar with it. I found Lake Powhatan with nice sites, OK showers and level campsites. Be aware the gate locks at, I believe 10:00, after which you have to park and face what could be a long hike.
I found Davidson River much more friendly, not as many
electrical sites, similar showers. It will be where I return this September.
This campground, as others, is run by volunteers. They have an exceptional crew that "work" the checkin and maintenance.
My all time favorite private campground is nearby,
Mama Gerties. An great choice, with more amenities, a different experience. Excellent reviews. Go large and pay the price for the mountain top campsites.