Beginner and want to be in a learning environment and laid back setting - Appalachian Ski Mountain
More challenging terrain, a bar, decent beginner amentities and long runs - Sugar Mountain
Resort-esque experience and a high speed quad - Beech Mountain
Get drunk, slide down a hill and hang out with your friends - Go tubing at Hawksnest, they arent skiing there anymore.
Beech has great terrain but the way the mountain exposes the resort it can be wicked windy and blow fresh snow all over the place, also it gets a lot of fog. Get it on a good day and its one of the better places to ski in the south.
Sugar doesn't have the high speed lifts but you can cruise groomers all day long if you stay over toward Red/Green lifts. Want to get the most out of your money, lap that setup all day. Ignore the long lines at the bottom or occasionally get on at the midway point. Expect the snow guns to be on if it is below 34*, Gunther, the mountain manager, will make snow at just about any time. They have a bar on site too but dont expect dollar beer specials.
Appalachian is your "family" mountain. Top notch ski school, even better terrain park crew and a staff dedicated to developing the mountain to have the best conditions possible. It is small, but don't let that deter you. It can be a lot of fun for someone just getting into it.
Snowshoe is a hell of an experience, especially if youre there during a storm. Only time I have ever hit waist deep powder on the East coast other than Jay Peak, VT. However you pay Intrawest (their management organization) prices. They are an international resort company so you get that experience along with the prices.
Avoid the holiday weekends, it only makes the already crowded slopes worse. Go a week before/after MLK and Prez Day weekends and don't even bother over Christmas/New Years when the Floridiots raid the area with their no driving, highway plug, horrible skiing but spend a butt load of money skills.