Definitely worth a trip if you're in Toronto. I was a little skeptical on this seeing as i've been to the top of the Empire State Building and other tall structures in other cities but this definitely is worth it. It was 60something US dollars total for two people for the ride up and skypod.
The glass floor they boast will make even the bravest person think twice... I have no problem with heights, roller coasters, drops or anything like that but for some reason the split second before I put my foot down on that glass panel my brain said, "NOOOOOO...!!" It is quite safe and fun actually to look straight down.
We got lucky heading up too. They said the wait was about an hour+ but it only took about 25-30 minutes in-line-time to get to the first level. The inside deck is cool but outside is even better. Elevators up to the skypod are tiny and only hold like 10-12 people so getting back down when its crowded up top could take a while; we didn't have a problem though. The sinks in the bathroom are nice too... you'll see what I mean when you go lol.
All in all, if you find yourself in Toronto head over to the CN Tower. And check out the little beach thing with yellow umbrellas by the water. Awesome time.