For mine the Lake Louise is best when it turns it on. Plenty to check out:
Lake Louise 2hrs
Norquay 1h and a bit
Nakiska 1ish hrs
and beyond that:
Panorama i haven't been
Kicking Horse 3hrs
Kimberly haven't been
Enough to keep you interested for awhile.
Poutenen will give you the lowdown on driving time as he is in Calgary.
Pano, norquay, and kimberly don't get a lot of good reviews, which is why i haven't gone. So many great places to go anyway. I actually haven't been to castle (driven by) but i hear great things and plan to check it out this year.
I don't care for Nakiska unless it gets pounded with snow. Then the monster glades are fun.
Sunshine has great snow and is close.
Louise has a better park and longer runs but not as much snow and it gets icy faster than ssv.
Kicking horse is super steep.
Revy has great trees and snow.