In a word - stunning! Every where you look there is a picture. I can't begin to do justice to the area, so if you're looking for a photographic journey through the Canadian Rockies, I recommend Darwin Wiggett's books.
Get up early, enjoy the great light, and be prepared for all types of weather.
Banff
Lake Louise
Moraine Lake