I went to C of Charleston for two years right out of high school in the late 90's.
One thing that will get really irritating are the confederate flag bumper stickers. "The South will rise again!", "North 1, South 0, Halftime".
The people are more stupid in general, but there should be enough smart people to keep you happy enough. Lots of northern transplants too.
It's quite geographically isolated, but the winters alone should make it worthwhile.
There are some cheap golf courses for year round fun, with lots of Canadian geese in the winter time.
If you go to Folly Beach, keep walking to the left to the end of the beach. It turns into an inlet where dolphins chill, and you can stand on the shore and watch them from like 5 feet away.
If you can get your hands on even one of those little tiny sailboats, it will be well worth it, and lots of dolphins in the harbor.
Great seafood.
You still might miss NE after a while, and you'll gain more respect for the intelligence of the average new englander, but there are some great people down there among the Rush Limbaugh/GW Bush worshippers.
CofC beat #1 ranked North Carolina when I was there, and we had a nice little riot (I just watched the vandalism), but I think the program has fallen off since then. Still should be a decent enough level of basketball to make going to some games worthwhile for sure.
You'll have fun, and will enjoy your visits home as well.
Good move.