I lived in the Triangle for about 3 years, and really liked it. Granted, this was 10 years ago, when I moved en masse, with about 12 other Ohioans, sure that our band's domination of the greater Toledo metro area would translate to similar mastery of the Chapel Hill scene (this was a miscalculation).
That said, I'm sure a lot has changed in the interim, but I found it pretty seductive. There was definitely some of that stereotypical southern courtliness you'd expect, coupled with a great foodie scene (in Durham, go to Francesca's on 9th St.; go to Fowler's for everything else), the aforementioned and widely-known music venues (Cat's Cradle, Local 506, Go! Rehearsal Studios in Chapel Hill were the obvious standouts), a surprisingly credible theatre scene (ManBitesDog in Durham, Playmakers Rep in Chapel Hill, Burning Coal in Raleigh), etc.
And if you need a trump card: may I present the Durham Dragons - LADIES SEMI-PRO FAST PITCH SOFTBALL, in the ballpark from "Bull Durham."
Don't get me wrong - I live in Brooklyn now and can't imagine moving back there now, but still - there was some good stuff down there.
Savannah is straight-up creepy, and not in a cute way. So is Charleston, SC, before someone else suggests that.