Okay, this is from a tourist perspective: For a city your size, your transit system is decent. Not great, but decent.
Your LRT (C-Train) system is actually the busiest in North America. Let that sink in for a bit, it's an absolute marvel that is very efficient in quickly getting you from one place to another along the corridor. Plus, your station designs are much more modern than other transit systems (Toronto I'm looking at you...), and honestly I like modern architecture as much as the service it provides.
Calgary does need to improve its bus services though. For a city your size I expected more weekend service on your various bus routes, and definitely routes that operate every 15 minutes or less at all times. For a tourist I guess it's not a huge issue, but I can see residents complaining about more frequent service. I guess I am a bit spoiled that Toronto has service of 10 mins or less on almost all its major corridors, but 15 min service for a city of 1M+ for all the major arteries at all times is easily manageable.
Your city is beautiful though!