I moved from the San Francisco Bay Area to Chapel Hill in 2002. Am currently in Apex (right next door to Cary, Raleigh & Chapel Hill), which was recently rated #1 place to live in the country by Money Magazine (
http://time.com/money/3984379/apex-north-carolina-best-places-to-live-2015-2/). Of course, pick your periodical and near any place can be rated 'best'.
I'm in software and fled the dot com crash to what seemed to be a location with good climate and employment opportunities, low cost of living and relatively little traffic. The area has (mostly) lived up to all billings. You couldn't pay me a million dollars to move back to Silicon Valley (though that's about what it would take from a housing parity perspective).
The area is really exploding right now with quite a bit of growth. Not sure if it is/not well planned/controlled. There are a dozen breweries within 10-15 miles of me, which is a ton of fun. In part, that's what's gotten me back into brewing after a long period off when kids and life in general got in the way.
People in the area are really friendly. And as mentioned above, there are people here from everywhere. It's a nice melting pot. I have not much experienced the hick/narrow-mindedness noted above.
The location generally is great - we're 2 hours from the beach, a bit more than that to the Appalachians and Blue Ridge Trail. I could go anywhere, but don't see myself leaving. Best of luck in your search!