All depends on what you want out of it I suppose. It's pre leaf peeping season yet so traffic is on the normal side. The weather is still warm but then you are from TX so you can handle it. I see your route will be mostly I-20....all the way to Florence SC then 95 to 40 and on into Garner. The only park on your way I can recommend is Tannehill Ironworks state park a few miles before you get into Birmingham. You might consider staying 2 days or so if you can.
I agree with going before the snowbird migration, they tend to clog up the campgrounds for overnight stops. I think anytime between now and Thanksgiving would be good time to go.