My favorite is Sycamore Lodge in Pinehurst, NC. It is a travel resorts campground so you must be a member of travel resorts of America or coast to coast to stay. It is very nice and relaxing. Nothing to do in the area, closest grocery store is 30 min so you can just take a deep breath and relax. It has a pool, nice playground, horseshoe pits, corn hole, minigolf, volleyball, shuffleboard, basketball, stocked catch and release lake, koi pond with waterfall, a waterwheel at one of the cabins, dog park, kids rec room and kids activities. It also has adult social activities like meet and greets, bands, movie night, haunted house in October, etc. Only downsides are it is hard to get a spot and almost impossible to get a full hook up/50 amp site. One section has really tight sites, the rest are s good size. Here are some pics.
Kerr Lake at satterwhite point/JC Cooper campground in Henderson, NC also gets a gold star. This campground is also in the middle of nowhere so don't come expecting to find a lot to do in the area. It is a state park so it is reasonably priced at $25/night. Some sites have water as far as 100 ft away but they all have 30 Amp hook up. It is a beautiful campground with gorgeous views, a nice playground, a great beach, boat ramp, and trails. Our site was huge and had waterfront access/views. Tight maneuvering the twisty campground roads with a forty foot fiver but well worth it.
Hungry Mother state park in Marion VA, small campground deep in the park 30amp hookup and water, no sewer but they have a dump station. in front of the park there are a few with full hookups. great place private lake canoeing, kayaking, fishing and a small beach for you swimmers, lots of trails to hike
For us the nicest place we have stayed has been Topsail too. The clean, pristine beach is the reason. Sites and campground are really nice also. Included a link for my review of the park with some additional photos peppered in.