We visited in October so the campground was not very crowded. The park itself is gorgeous, especially in the fall. Lovely fall foliage. The hiking trails are challenging for 2 middle aged folks- lots of climbing up, then down, at some pretty steep inclines. And the trails don't loop around on themselves so you come out a mile or more from where you started and just have to hoof it along the road to get back.
There is a boat ramp and fishing available, if that's your thing. There's no differentiation between RV camp spots and tent spots so if you are tent campers, like we are, you might end up next to a HUGE RV in the spot next door.