Afraid all my GA flying was done in Nova Scotia when I was in Canada, but did plenty of travelling to Calgary (as commercial SLF). Recommend the place highly as somewhere good to go - I had a great time there! Obviously, even better if you head towards Banff (approx 2 hr drive) / Jasper in winter!!
In terms of sightseeing, obviously Rockies must be great, but would also suggest Drumheller (which is around 90 miles East of Calgary), which has a
Dinosaur Museum and some pretty interesting rock formations around the valley. I haven't specifically seen them from the air, but I should think they're quite good.
Enjoy your trip!