Two weeks ago, my Scout troop (Troop 2 out of High Point)  used campsite 3 in the group area.  It was perfect for us.  We've stayed at several others before as well.  While a student at Wake, I hiked the trails frequently.   So, I know the park pretty well. 

The SP is in a great location, especially if you are in Central NC.  There is easy access, and good roads for a decent driver.  The roads are marked well.  

The park is also close to a good canoe/kayak rental outfitter called The Dan River Company.   (If you want a craft beer after your trek, they have a small tavern there.)

The campsites in the group areas were good and clean.  There were picnic tables and fire rings.  Our site actually had 3 fire rings with benches and 4 picnic tables.   These are rustic, which is fine for me.  If you are looking for showers and gravel tent pads, don't stay there.   Frankly, I'd just as soon as camp on concrete as a gravel tent pad.  There is also a mowed field next to the group campsites to play in or just chill and watch the stars. Oh, and the ranger basically encouraged us to hike and roam the park at night.  I don't think I've ever had a ranger ask if I planned to drive around a park at night. 

The trails to the top are made for hikers and people who walk.  You will not get up to either summit by driving or riding anything.  The trails aren't that tough, but are going to test you if you do not get out much.   I prefer the view from Moore's Knob.