The state and national parks have the best camping imo if you’re interested in sightseeing/hiking and having a campfire. I don’t consider third party campgrounds unless a state or national park (or BLM land) isn’t around or they’re fully booked. Picking which tent site within the campground is best is a bit harder sight unseen— usually they provide an overview of the campground online with the sites marked so you can make some best guesses based on proximity to the bathroom, site isolation, etc. Check for reviews of the bathrooms (a lot require quarters to operate the shower).

If Fall Creek Falls is anywhere in your neck of the woods I highly recommend it! The south has some of the best waterfall hikes.