Raleigh is a good city, I just wish it would stop sprawling. The Northerners have descended upon it though and have driven prices up artificially. Mayhem usually exists only outside of Raleigh mostly the closer you get to Durham or once you are there. Durham has a larger than average population of middle class African-Americans and white liberals which of course spells disaster. Raleigh is not like that at all at least.
Well, I lived in Durham...near Southpoint (and NCCU...do that math!), so I was near a lot of what you posted.
If I ever move back to the Triangle, it'll be Cary or Chapel Hill. For now, I'm loving Miami!