The Banff Gondola is a must do activity if it's your first time in Canadian Rockies. Yes, it's touristy but it provides absolutely amazing 360° views of the town of Banff and surrounding mountains from the top of Sulphur Mountain.
It runs year round and from mid-November to end of March, you can experience Nightrise which is an after dark multimedia experience at the top. Note that the daily spots are limited, so make sure to do your booking in advance.
Parking can be challenging during the summer months, but you can take a bus from downtown for free if you show your gondola ticket.
PS: If you feel like not spending on gondola tickets and hiking to the top instead, it's possible! Sulphur Mountain trail is very well maintained year round and goes up through switchbacks. It's a 10.8 km out-and-back with around 750 meters of elevation gain.