I've done a couple in banff and plan on staying for a while.
9/10 would recommend to a friend.
pros: shit ton of diverse terrain, really good parks, pretty good slackcountry, lots of other daytrippable resorts, nice views, heaps of good places to eat/drink, great locals, easy/cheap transportation
cons: hit and miss snow/vis, rocky and avy prone terrain is common, dipshit tourists, high rent/cost of living, STD capital of canada, sometimes the grocery stores run out of salad
pm me if you have questions