I lived and worked in Vancouver for a few years and had work reasons to travel to Edmonton on a fairly regular basis. It’s OK but pretty unremarkable (compared to Vancouver, say). As far as I remember it was fairly flat and everyone drove a pick-up! It does have things going on though; I have a friend working at the Uni of Alberta and she loves it.
The weather is typically continental: dry warm summers, bloody cold winters. I would say that it isn’t that close to the Rockies, but if you are prepared to drive 4-5 hours for a weekend away, it could be a good location. No idea what the cycling is like locally.
After having lived/worked in Canada, I would say go for it. It’s a great place to be for a while.