We have both.
Queens chariot is an Acura MDX with awd
Mine is a GMC Sierra with selectable 2wd, awd, and 4wd. DD gets 2wd of course. If roads are wet, I'll put it in awd, though I do not need it. I look at it as it may prevent a slick curve or loss of traction taking off uphill, of which we have both in abundance. Snow, like we got last night, sometimes I will use awd, sometimes 4wd. Just depends on how truck acts. 4wd for off road.
For what its worth. I used to have a Chevy crew cab dually, Duramax diesel, 4wd. The truck itself weighed in at 8000lbs without a driver. You would think due to its weight and length, with 6 tires on the ground, it would do well in snow, and you'd be right. But in snow less than 6" deep or so, the Queens Acura MDX with their SH-Awd system would do better.
Ice? Ice doesn't care what ya drive, it'll put ya in the ditch.
Mud, rocks, ruts, 4wd where wheels are dedicated, usually do best. But with todays technologies picking and driving wheels by sensors, todays awd systems do do pretty well.
You also can have front and/rear mechanical and/or electric lockers that help in certain situations.
Short version; if your not truly off road or deep snow, awd is the way to go.