Here right now. The main reason I don't want to move here to be with family is it's all suburbs/exurbs with no public transport to speak of. If they ever build a streetcar/light rail system between Raleigh/Durham/Chapel Hill, this region could attract people away from bigger cities, no doubt.
There is a lot going on in Raleigh and Durham. RTP is just a corporate zone with a lot of businesses. If you want life outside of work, head 15 minutes in either direction to Raleigh or Durham. Both great places to be on the cheap!