If you have a toad or other transportation and plan to do some touring, almost anywhere is game. Without a toad your RV park becomes a destination or you have to do what I have to, and unhook and pack up to go touring, and I'll second Ft Pickens, especially if you like the beach, walking trails, history, nature, etc. If old enough and have a Federal Interagency Senior pass, Pickens becomes a real deal. Gate fees are $20 good for seven days, but free with the Senior or regular annual interagency pass, and campsites are now $40 a night but half that with the Senior pass.
https://www.recreation.gov/camping/fort-pickens-campground/r/campgroundDetails.do?contractCode=NRSO&parkId=97219 The A loop and C and E loops are your only options, B and D are now classified as Tent only as the sites are short and have low hanging limbs throughout. C and E are more open than A which has more trees. Both have good showers and dump stations.
Big Lagoon State Park is also a good place to stay. (Pensacola area, west side, closest park to the Naval Aviation Museum).
As noted, consider the Alabama Gulf Shores area and also west side of Mobile Bay is Dauphin Island, County operated campground, Estauarine aquarium, pre civil war fort, Audubon Sanctuary with walking trails, and places to eat seafood (I have not been, it is next on the list) on the way thru Mobile you can stop at the Battleship Alabama and related displays.
Charles