As to the OP, you really need to decide what you want in your lifestyle.
I am very familiar to Charlotte, there is alot to offer. I lived smack downtown and could walk to everything. There are good restaurants, movies, sports, bars, light rail, etc.
My colleagues lived primarily in Huntersville/Birkdale area. It is a nice community, very middle mid to upper middle class. Nice picturesque outdoor mall. Closer to Lake Norman (i.e. the Penninsula, Cornelius), you get the gated neighborhoods full of NASCAR drivers, Joe Gibbs, NFLers, etc
Also had a relative in Ballantyne ... To me, more pretentious area. Btween Pineville and Matthews, it has nice areas, but seems to be more "keeping up with the Jones" type of place. It is the "5th ave" of Charlotte if you will.
Matthews is more rural, more house for the money. further away from action.
NoDa (North Davidson) is an artsy fartsy area. Nothing wrong with that, great indie bands, rejuvenating the area, fun arts and pubs.
Going further south, outside of Pineville, you et to Waxhaw/Union Co. which is McMansions for decent price (3250-400K for 4000sqft). Not sure of schools, I hear CMS school system is really bad, but like all cities, there are pockets that are pristine (Ballantyne, Pineville, etc).
You can also live in SC and work in Charlotte, traffic only sux for about 45 minutes from 450-530ish.
If you want to avoid taxes, live/work in SC on the border (20 minutes to Charlotte). NC has a 8% income tax, pretty high property taxes and 9% sales tax. Its not much different than California. I moved to NC from Tennessee and that was a harder transition than NC to Cali (except house price).
Feel free to PM me if you decide on that area. I really enjoyed downtown