The area surrounding the three B's (Boone, Blowing Rock and Banner Elk) are our pick. Higher elevation with a good mix of everything you'll ever need as far as grocery and shopping go. Beautiful Lake Watauga is close by and the area is a great base camp for exploring the region. Just look for property out in the country and nice homesteads can still be found in the area.
We personally love the college vibe of Boone and the incredible App State football games and community there that supports them. Brings a great vibe of life to the area which can be enjoyed year round, with hiking and waterfalls, leaf peeping and skiing/ snowboarding to be enjoyed too. We spend a good amount of time there as we live close by in TN (under an hour) but love our home and community here too much to make the leap to move there as we have kids and careers connected to Weaverville, NC / Johnson City, TN.
Over the winter our son had committed to App State which we were ecstatic for but at the last moment moved over to ETSU (Eastern TN State Univ) as he received a generous scholarship from them and their program for physical therapy he liked better (not to mention the in-state tuition savings / boarding from living in TN) so he switched. We were pretty bummed out but we have two kids coming up behind him so our App State dreams may be eventually become a reality.
If it were me I'd stay far away from Asheville and surrounding (especially downtown and areas to the south) and only visit there on day or overnight trips. The area there is getting too touristy, pretentious and crazy overall, with shootings there seemingly on a weekly basis now. Such a shame as it used to be a nice area and there's still things there worth seeing, but nothing worth living nearby for in our opinion.
Another great area with your requirements is Jonesborough, TN. Check out the downtown area and proximity to everything Appalachia. Beautiful farming community surrounding it with TN tax advantages, incredible scenery and reasonable property values if you search around.
You may hear from people that the areas mentioned here are "XX minutes from Asheville" as though it's a bad thing, which to us it's just the opposite as we've been there, done that with our search too, one that was similar to yours. Good luck with wherever you land.