This is more of a drive-in picnicking park than anything else. They have some activities and areas for games, but I wouldn't really consider it somewhere to camp.
My college friends go here each year to meet up and we have so much fun. The group sites are great and perfect for our 30-50 people. Definitely go for the rafting/tubing package, it was the best part of the trip!
We went on Labor Day weekend and literally every site was booked, but for good reason. Really great and surprisingly long hike to the old lighthouse with lots of area for playing games and swimming.