Regarding the "recent developments", RTP jumps out on the following map:

http://www.wral.com/news/political/page/10991843/

Durham and Orange Counties voted no by over 2-1 margins. And meanwhile, Proposition 8 passed in California a few years back; indeed, such propositions have been passed everywhere in the US where they've been put to the voters as a whole. North Carolina is not distinguished in this respect.

I personally like San Francisco over RTP, despite originally being from Durham, but there is a lot that is very good about the RTP area, and I personally know a lot of very talented people who are extremely happy (if, admittedly, a little bit less so this week...) to call it home.