Your coming from NY, correct?
That is a great area. My family has roots way back in the hills right where your considering. (little sandy much and shelton laurel) Beautiful country. IF you come down for a visit post up and Im sure youll get some pointers.
Brevard is quite nice as a "quaint" town and its literally next door to all the adventures Pisgah Nat'l Forest has to offer (biking, hiking, paddling, etc) This area is southwest of asheville instead of NW but close b
Fairview has been really nice but changing lately. Lots of growth when Tiger decided to build a course there

(musta had a local mistress) Wish we still had the family farm in that area. (tlca todd kaderback is from here)
Waynesville is a very cool town just outside Maggie Valley. Cool and quaint downtown w/ independant stores lining the streets. and a tire store open on a sunday afternoon that sold me and mounted a used 35'' MT for 25 bux
Bakersfield, and Burnsville both are pretty nice, a little bit more out there feeling but only half hour from asheville. Land is a bit more affordable.
REALLY nice spots of Highlands and Cashiers but $$$ ; worth a look cause it might only be $ in your eyes
Continuing along the TN/NC border going north you start heading towards BOONE NC. Nice area again, I would go outside the college town realm though into areas like Roan Mtn. and Newland. Might be missing the access to the "Big" city your looking for but oh so close to Linville Gorge.
getting away from the border I'd look into the Lake Lure area. (last of mohicans filmed here) Very nice and lots of upscale developments and private lands still available. Look along Hwy 9 south of I-40 b/w black mountain and fairview. Actually know a couple w/ a lot for sale if your interested....but gated community style if thats your cup of tea.
If you look at asheville; west side is the trendy side. Was the lure to all the "hippies" attracted to asheville +/- 5yrs ago when the "yuppy" trend moved in. Now the yups are invading west asheville making it theirs too. Rough generalizations there but you get the point. I cant afford asheville but from what ive seen I really like North and West sides of asheville. I was looking at Woodfin for the north and Candler in the west. Just outside of town but a 15 min drive to Downtown asheville and way more affordable.
Hope that helps some and wasnt too much to digest.