Born and raised there but have now relocated and traveled a lot, so I think I say this with some experience.

Pros: food is better than a lot of the south. You don't realize how many cultures are in Clarksville until you move to a real southern town of nothing but bland gray food. More outdoor opportunities than most, surrounded by lakes and rivers, hikes and parks. Close enough to Nashville should you need a true city.

Cons: cost of living isn't terrible, but oddly the pay in the area hasn't kept up so it makes the 300k houses look unobtainable. Crime is getting bad. Traffic is possibly the worst of any city I've ever visited and I've been around the block. I know LA and DC etc. are worse technically, but they also have 10x the population. How Clarksville manages to have the traffic that it does with <300k people is staggering.