We are transplants to Middle TN from NW PA. I was very nervous about moving here, but was won over when I came on a business trip with my husband. It is so beautiful here it took my breath away!
We've been here for almost 7 years, and honestly my husband has passed up moving up the corporate ladder so our family can stay here. It is VERY different than living up north in A LOT of ways, but once we got used to it we love the atmosphere. It is very family friendly. People are generally super friendly and kind. We live near Nashville, so we have loved being able to access the music scene and show family around when we have visitors. I love though, that we are close to the city, but still live fairly "rurally".
Being from the snow belt, we LOVE the weather here! :) It did take about two or three summers to get used to the heat and humidity, and some days it gets hot/humid enough that it is just better to stay inside, but most of the time we enjoy the weather. We were at the park playing in t shirts about a week ago. The downside is that when they get even a few flakes here, things shut down immediately. And while we used to laugh about that, we have learned a very healthy respect for black ice and we tend to stay in now when it has been wet and gets cold.
This is the buckle of the Bible belt, so there are some positives and negatives about that, but all in all - we absolutely LOVE this part of the country, and I don't see us moving any time soon.
My sister lived in SC, and they couldn't wait to get out of the area. Not exactly sure what all her gripes were, but they were never happy there. She has three special needs children and I know the p.s. there wasn't very willing to work with the kids to meet their needs. It was a really long, hard road for them with their school district (which probably wouldn't be a factor for you), and they were happy to relocate to central OH.