I've been pondering future trips to away games, I didn't realize that most of the cities were so small. I've been to Baton Rouge, Knoxville, Nashville, and Lexington for work. Passed through Gainesville while moving back to Texas. College Station a handful of times.
The airports are acceptable, but a lot of times it looks like hotels are going to be 30-50 miles away. Not a deal killer, but most likely would cause you land at Columbus,Ga or Montgomery for an Auburn game. Or Memphis for an Ole' Miss game.
Looked at Knoxville as an example of one of the bigger SEC towns but even they have limited hotel space. If you look at their downtown Hyatt Place for their game against Aggy, it's asking $1100/night.
I have friends that will fly in for the game and fly out right after, but I've gotten to the point of wanting to be a bit more relaxed about the weekend.
Oxford, Knoxville, and Gainesville are high on my list. Maybe Nashville, Tuscaloosa, Columbia, SC and Auburn just a step behind.