Don't know Calgary, but had a great time staying in Kalispell. The drive from Missoula was especially beautiful in the Fall. To see Flathead Lake, and all of the wildlife always made "Big Sky", a special treat for me. There were all kinds of "Rustic" places to stay and enjoy yourself.
My husband is already talking about specific locations where he wants to take pictures. Thank goodness for digital cameras--I bet he will take 1500-2000 pictures a week!
We were in Vancouver for 3 days this past summer following an Alaskan cruise. We loved it and hope to go back someday. I'm sure you know about the Marriott there.