We moved down here from Pennsylvania almost 5 years ago and have enjoyed every minute. We really miss our friends from up there, but that's about it. Just like everywhere else, there are good and bad areas, but Lexington is almost all good,...and, no, I don't work for the Chamber of Commerce.
First of all, Lexington (Columbia-area) is known as 2 hours from everything, and it is: The beaches, historical Charleston & Savannah (GA), The big city (Charlotte, NC), the mountains, boating, hiking, lots of golf and, of course, the beautiful weather to enjoy it all. You will never run out of places to take the family.
The schools in Lexington (specifically) are amazing and award winning. Our kids are in elementary, but we have many friends with high praise for the middle and high schools too. Speaking of friends, we've noticed that Lexington is a melting pot of the South and the North without prejudice to either. The people here are wonderful and friendly.
Restaurants (my field) are fine with a blend of Southern cuisine and just about everything else. Many people here enjoy their meat & three (veggies), but still no chili parlors,...yet. House prices are very reasonable, but be weary of construction. Palmetto trees, bermuda grass and pine straw (no mulch?) are everywhere as landscaping.
The weather is really nice. Everyone warned us about the humidity, but it isn't nearly as bad as you think and it isn't very long. The Spring and Fall are long and glorious, Winter is short and spotted with an occasional dusting of snow (although we got 7" this winter - melted within 48 hours).
Hope to see y'all soon!