I am in Mid TN, moved here 1.5yrs ago from Orlando. We live 30 min south of Nash in Franklin. Very nice area with highly rated schools. Can find neighborhoods in this area with houses in mid 200's all the way to >1mil. Can get a very nice house + acre or two in the 500K range. Property taxes are low & 0 income tax. State & county sales tax = 9.25%.
Franklin/Brentwood area very family oriented, Franklin more so than Brentwood. Brentwood tends to be a little pricier than Franklin in general. We are younger, but have 3 children & Franklin presented itself as a great place to raise a family, which has held true to date.
If younger w/no kids & don't want the burbs than Downtown Nashville has some fun areas, but for resale public school system is the horrible. The night life is entertaining in the area & not what most are used to because country music is so prevalent.
In general TN is an entirely different lifestyle than where I was in FL. Friends from CHI have said the same thing. Generally speaking the people down here have a different value set than other places around the country & good old southern hospitality seems to be ingrained in everyone. I am speaking more for Franklin than else where in the area as that is what I am familiar with.
The only way you'll like it is if you really want a different kind of lifestyle.
Any other questions & I will try to help.