Bow Lake in Banff National Park is in my opinion the most photogenic place in the entire area. Some people would vote for Peyto, others Lake Louise - but I always find myself coming back to Bow. The weather is dramatic, there's a great hike up to the falls - or if you're more adventurous you can stay overnight in the Bow Hut (but that takes a bit more planning).
You really can get a sense of the majesty of the Rocky Mountains standing on the edge of Bow lake. A sense of how hard they might have been to cross. It makes you feel - small and inspired at the same time.
I'm glad the Rockies are my backyard.
What places make you feel both small and inspired?