If you're in Calgary, this is one place that should definitely be on the list. While the tower has now been dwarfed by many taller buildings around, it still gives some amazing views, especially in the east where you can look all the way to the horizon and west where you can get a great sight of the amazing Rockies.
We went on a weekday, which is probably the best time since there wasn't any rush. The base ticket is just around $18, with even less for seniors. If you look online you'll find deals that can get you around 20% discount as well. The guided tour (with headphones) is $4 extra but we didn't take it and I suppose it's not that necessary as well if you have the patience to read everything.
On the top, besides the 360° view, you also have glass floors placed at certain places in which you can stand (if you don't get scared). The views are amazing. They also have 10-15 minutes free shows at regular intervals that take you to the journey of the tower's history which is definitely a watch to understand the tower's importance for Calgary.
One level below the top, there is a restaurant in case someone wants to dine with a great view of Calgary downtown. We didn't go there though. The tower exits to a souvenir shop which is good to checkout.
The staff, in all places, was great and helpful.
Overall, this place should definitely be on your list.