A nice small town near a major metro.
I lived in Columbia, TN for about a year and enjoyed it greatly. People are friendly and there is not a serious crime problem or staggering cost of living.
Columbia is about 35 minutes from downtown Nashville so you have the sensation of living near a big city without the headaches of traffic
and other larger urban problems.
There is a decent array of chain restaurants and some nice local ones, although I'm sure the names have changed on many since I last visited.
The James Polk home is located here and is worth a tour. There are some interesting older homes and
the city is located in gently rolling hills with some quaint neighboring communities.
"Mule Days" are big here in the summertime, and there is a huge parade and celebration. It is an easy drive to any major event in Nashville for the night or weekend.
The only downside I recall was that the town seemed to shut its doors around 10 each night, but if you are looking for loud nightclubs and partying, you can always do more of that in Nashville. If you are looking for a nice relaxing weekend in a smaller town, Columbia should be a fun little stopover for you.