The CN Tower was the reason I went out of my way to drive one hundred kilometres to Toronto. It was amazing. Beautiful night lights, amazing view from the SkyPod, and one of the best (if not only) things to do in Toronto. The restaurants and admission to the tower itself is expensive, but once you get to the observation deck, you'll be blown away by spectacular views.
Once-in-a-lifetime experience, would recommend for anyone.