Not so much on the eastern side. I've stayed at Isaac Creek Park, a CoE on Lake Claiborne northwest of Monroeville. A long way off from civilization (about 27 miles to town), but very scenic. I'll be going back with my new folding kayak because the sites on the east side have semi-private boat docks in Isaac Creek itself (one dock per three sites) as well as about 95% tree cover. The sites on the west side are more open but have nice lakefront views.
There are several CoE campgrounds located on West Point Lake right on the Georgia border, but I haven't stayed at any of them yet. Check out the Corps Lakes Gateway for informationů http://corpslakes.usace.army.mil/vis...cfm?Id=K519710
I'll be staying in Meaher State Park in May this year for a rally with my WBCCI Unit. It has very easy access to the USS Alabama battleship since it's right on Battleship Parkway, though across the bay in Spanish Fort.
Monte Sano State Park near Huntsville is also nice, and conveniently located within an easy drive of the US Space and Rocket Center in Huntsville.