Shit so far this year most days you could ride a scooter up into the canyons and over the passes but if it's puking your going to be driving the car and then getting on a ski or resort bus.
You should be able to use any vehicle to get you between the 3 resort areas which are Little\Big Cottonwood Canyons(SLC) + Park City + Ogden but once in the general area you'll need to ride the ski bus to get to the lifts which is not a big deal.
For me(if you have a 2-3 people) I'd rent a small subaru impreza their only a few $$$ more than the shit mobiles and then you can keep all your food and drinks in your car right next to the hill to save money that way and not have to deal with the bus bullshit.
so pay now or pay later and enjoy the convenience of having your vehicle 200ft away in the parking lot.
I'll see if Thrifty has any AWD cars I can upgrade to. We're planning to go to Snowbird and Park City.