Um, yea. The CN Tower is A-OK. I'm not a big fan of these types of attractions. I don't think I liked the Space Needle in Seattle, the Sears Tower in Chicago, the Empire State Building in NYC, or the Oriental Pearl in Shanghai. The only time I ever felt like I got my time and money's worth at a observation deck was at Taipei 101.
This experience is pretty standard. You pay a lot of money to wait in a line to take a crowded elevator up to the observation deck. There, you look outside though you have minimal guidance/description on what you are looking at. Then you go down one level where there is a tiny part with a glass floor. It's not scary at all because it's completely covered by dozens of other tourists anyway. Finally, you wait in an even longer line to take the elevator back to the ground floor so that you can say that you've visited the CN Tower.