If you want nice snow, go to the west coast.
We ski Breckenridge, Colorado a lot, and it can be somewhat crowded in certain areas, but you can always switch mountains. However, I don't believe they offer snowtubing.
Then Vail is always super crowded. Especially on holiday weekends.
Then Heavenly Valley Lake Tahoe, CA is absolutely fabulous.... it can get pretty crowded, but once again, it's big. Once again, not sure about tubing.
Big Sky, Montana is soooooooo cold. I mean frost-bite cold. Layer your long johns and pray you don't freeze cold. Same with Whistler (not to mention, Whistler is extremely expensive).
Transportation-wise, Breckenridge is more accessible because you can stay at a ski-in/ski-out resort. At (North) Lake Tahoe, you stay at the base and take a gondola to the top of the mountain and ski down the other side. So, it's easier to get back to your resort at Breckenridge. Though, personally, I prefer Lake Tahoe snow.... all powder. Breckenridge can be a bit icey in certain areas.
You're more likely to find snowtubing on the east coast, I believe. I've been tubing at Snowshoe in West Virginia, and they have a super fun course. It's least crowded at night (though rather chilly). Depending on your resort, you could have ski-in/ski-out. It can get kind of crowded, though. And they have to make a lot of their own snow. It's icey in the morning and can get slushy in the afternoon, depending on the weather. However, they offer a lot of extras that west coast resorts can't offer due to temperature, such as snowtubing, snowmobiling, horse carriage rides, snowshoeing, etc.