We really like Maggie Valley because it's close to most everything but not "busy" and we always stay at Stone Bridge RV Park on Soco Road. It's a nice park with a pretty stream along the back side--a good BBQ place is within walking distance and just across the hwy is a place where they carve bears, etc. from wood using chain saws (interesting to see)
Here's a few things I would recommend to see/do in the area:
1. Waterfalls--Soco Falls on Hwy 19 between Maggie Valley & Cherokee; Mingo Falls on Big Cove Rd about 5 miles out of Cherokee; and in Transylvania County, NC, there are lots of waterfalls of all sizes.
2. Someone mentioned Waynesville and the Mast General Store. I would also like to mention that within a block or so is a great pizza place--Nick & Nates.
3. From Waynesville heading toward those waterfalls, you will cross over Cold Mountain (of the book and movie)
4. As others mentioned, you can get on the Blue Ridge Parkway just west of town.