Salt Lake City is definitely the place to go for what you're looking for. The airfare typically cost more to get to SLC than Denver, but the close proximity to 7 resorts, cheap lodging and UTA ski buses more than make up the difference. My son and I just went over the Easter weekend and it was a great experience. Stayed at the Days Inn South for $53/night, which had a fridge/microwave and 2 beds. Nothing fancy, but clean, cheap and close to the slopes.
Unfortunately, the ski buses had stopped running the weekend before, so we had to rent a car (a 4x4 sport ute, in case the roads got restricted...nothing worse than not making it to the mountain). Next time we plan to go a weekend earlier and stay in a hotel with free airport shuttle, then take the ski bus to the mountains. We'll save a couple hundred bucks.
Another possible great ski deal option-- Reno, Nevada. They often have great travel package deals to try to get gamblers in the door...$15/night mid-week lodging deals are not uncommon, plus cheap airfares. Mt. Rose is only about 25 minutes away (ski shuttle is only $5 R/T I believe with lift ticket). If you want to ride a bit further, there are FREE ski shuttles to Northstar and Squaw Valley (both Lake Tahoe world class resorts) that stop at all major casinos every morning. Nearly all casinos have free airport shuttles, too, so you can get by without a rental car.