A trip up 85 would do you good to see everything for yourself... obviously thats just my opinion.
But I'm also the creative designer/southern guy who seeks culture type, lol. Charlotte is just sterile to me where it should be inviting and shady where you should be able to live with peace of mind (of course, durham probably has a higher crime rate, but i doubt you would move there anyway, i just like to visit for the historical value). It's like one of the largest financial centers in the country. Of course you could always live in mooresville or concord for a nicer home life.
As a designer/artist raleigh/triangle area seems more enriching to me as a whole. more history, variance, and intrinsic value.
like i said, if you like atlanta, you'll like charlotte, only charlotte doesn't have as interesting of architecture.
Check it out on the way up and then give me a call and we can meet up and I'll (maugan too?) can show you around the triangle.
it's all relative!
Good luck with it all!
technocoy