I think that the CN Tower is a beautiful free standing structure, very pleasing to the eye. Great tourist attraction trap (since there is nothing much up there) the view is nothing spectacular to look at. The restaurant is mediocre but worth to dine there and visit the CN Tower for free ;)
What's even better now is that they added the aquarium downstairs, so more reasons to come to the CN Tower.
The CN Tower is a great way to symbolize that you are in the core of downtown Toronto, and that you can see it miles away (so you always know where dt is) A great addition to have in the city of Toronto.
I appreciate this structure even more now, after climbing up the 144+ floors of the CN Tower stairs for charity.