Spent 4 nights here (during a heat wave, no less) and really enjoyed it. Campsites are large and not right on top of each other, and especially if you can book one of the campsites that are on the water, they really do have beautiful views (see pictures).
Pros:
Kid-friendly. We spent an afternoon at the splash pad, which is a great way to cool off in the summer and free once you're in the park. I never felt unsafe with my kids running around up to the bath-house or the loop, felt very secluded and safe.
Lake is scenic, we saw fireflies at dusk, it was a great setting for a camping trip.
Everything seems pretty well-maintained. Bathrooms are aging but were cleaned at least once a day, it was fine. There is firewood at every bathhouse you can take on the honor system and pay for via cashbox, which is nice. Campsites are clean and well-maintained.
Lots of lake recreation options (boat rental, fishing, etc.) in or near the park.
Cons:
Maybe it was just our campsite, which backed up to a large wooded area, but they were the most aggressive squirrels I've ever come across. If we went to the bathroom for five minutes and left food on the table, the squirrels would be there eating it when we came back. And would hover at the edge of the campsite or get into the car if the hatchback was open.
Camp store is....fine, pretty minimal in terms of provisions. But not a big deal because Clarksville is five minutes or so away and has plenty of stores.
Tents pads are all gravel. Didn't bother us but definitely would not want to tent camp here if you didn't have a good high-quality sleeping pad.
The biggest con was that there is no swimming area/beach in the park. You can try to wade in from the campsite but that generally requires scaling up/down some fairly treacherous rocks, and navigating driftwood and rocks in the water. We drove a few minutes away outside the park to find one, but would be really nice to have some kind of little swimming area inside the park, very strange to me they don't have one.
But all in all a lovely place for a camping trip, we all had a great time.