We took our 5 and 3 year old sons camping here this past weekend and had a great time.
Site: Our site was on the Hard Times loop which offered huge, flat gravel pads (our site was an RV site but also perfect for tent camping since it's pea gravel and not paved). If you have a 6-person or larger tent, opt for a gravel RV site, as you'll get tons more room than the "tent-only" sites which have the tent pad surrounded with railroad ties.
Facilities: Powhatan really takes care of their facilities. Restrooms were cleaned multiple times per day and the showers are clean and the water was actually hot - awesome after a day of hiking before jumping in the sleeping bag. Gate house sells ice and firewood too.
Activities: Tons of trails within Bent Creek but are mainly geared towards mountain bikers. Had to be on constant alert with my kids and dog, as the bikers absolutely bomb down these trails. Similar to hiking in Dupont but with a heavier concentration of mountain bikers. This was the only downside of camping here but there are some great hiking-only trails off the BRP just 30 min away. I wish the trail system worked its way through the campgrounds, as we had to walk a ways down the main paved road to access any trailheads.
First visit this past weekend for an off-road weekend at Uwharrie. We had a crowd of 12 and booked one of the "double" sites, which was well worth it.
Massive fire ring, two picnic tables, flat ground for 6 tents and surprisingly clean bath house. Great campground and, if you like Jeeps, FJs, Broncos, you'll be in heaven.