Charlotte North Carolina

I'm sure you've already checked google maps.

I think there is only one possibility for the type of campground you have described:
McDowell Nature Preserve

March 2017 we stayed at Andrew Jackson State Park (South Carolina), just South of Charlotte. It was an absolutely - fantastic - wonderful - great - beautiful - fabulous - campground. All the spots are asphalt, (although hilly, so bring something, and plenty of it, to level your rig). But absolutely a marvelous campground! We were there for a week and visited family who recently moved to Matthews (Charlotte) NC.

Southwest of Charlotte off I85 about 45 miles.

https://www.tripadvisor.com/Attraction_Review-g60876-d2331473-Reviews-Kings_Mountain_State_Park-Blacksburg_South_Carolina.html

I am staying here in July. Never been before.
York County Ebenezer Park

I also stayed at kings mountain. I posted some pictures here.

I would look at Kings Mountain State Park. just down I-85 from Charlotte. A very nice park. Has water, and electric. Has a dump station as well.

Just to REALLY wet your appetite, here's some photos from Andrew Jackson State Park (SC), March 2017.

Here's our campsite (the Outback):



Here's the view of the campsite looking out the back:



Here's a slightly different angle from the back. The tent belonged to the next campsite over:



Here's the view of our campsite from across the lake. We are the white trailer to the left in the photo:



Here's another shot from across the lake:




We made new friends:



Saw new sites:




and ate REAL good:







Now.... go book a reservation!

I agree with Kings Mountain State Park.

X 3 on Kings Mtn. Little history there as well ;)