It's 0120 in the morning and I'm still wide awake (if not wholly sober - 2 Blackberry beers from Sam Adams and I'm done - damn lightweight) trying to track the storm. It's not like I'll be able to change it's course or anything.
I remember using weather tables from one of the Dragon Magazine issues (somewhere in the 80's or 90's issue wise) and rolling campaign ending weather on my players - something like a 4 day blizzard with 5 1/2 feet of snow. Sorry, but that's once in a milleneium weather event. That's the Ice Age.
Weather in a RPG should be adjusted to fit the story - need a blizzard or a hurricane? Add it to the story. It's really that simple.
I love random tables and hate them at the same time, as some GMs allow themselves to be ruled by "the random". If the results don't fit, you must adjust. Or change gloves- wait, that's O.J.
On that note, I think I'm no longer as wide awake ;)