I grew up in NC and have stayed here except for a 4 year stint in Richmond. I guess I am here because I grew up here, went to college and grad school, found a job and never really left. I stay in NC for all of the reasons that you mentioned in your post: the weather is nice (though it snowed yesterday), cost of living is low, property taxes are low, employment is strong, education is strong, the beaches and mountains are both within a few hours drive (but no good snow skiing).
Real estate specific, the area where I live has buy and hold potential when you buy right. Appreciation is hit or miss...head to Charlotte or Raleigh and look at their trendier neighborhoods if appreciation and/or flipping is your game.
Sure there are better areas for cash flow (on paper), but if I have to shovel snow 5 months out of the year or have my rights infringed upon (we won't go politics), then I'll pass and just stay here in the south.
@Kimberly T.