I also got stuck with Nortworst in MSP on Friday night on my way from LGA to YYC. At about 11 pm there were a total of three customer service reps with an attitude of "we do not need this tonight either", handling about 25 people with missed connections. For me it took thirty minutes, for some others it took longer. No hotel paid, just a phone number you could dial up for a "special rate". The best deal in town they had available was $61 in the Doubletree. On top, the next NW flight to YYC the next day was only after 11 am and it was full. Next flight with availibility only at about 4pm. No stand-by list for the early flight, I had to come in person. Luckily I was able to make that earlier flight (with one hour delay due to mechanical problems).
There was a young guy who was not able or willing to pay for the hotel. He was offered a blanket to sleep at the airport.
I have had very few delays through inclement weather, but the last one I remember was on AA and I received a hotel room, they booked me on another airline for an earlier departure the next day, and they gave me meal vouchers.