WOW! This is the appropriate word to describe the view from the top of the CN Tower. The entrance ticket it's quite expensive (25 Canadian dollar + around 10 dollars to go on the real top) but it worth a visit absolutely!
The elevators goes on top of the 350 meters only in less then a minute (amazing!) and once you'll be there you could see all the town, the Ontario lake (that really looks like a sea!), the shining buildings of the Financial District, and if the sky is clear you can also see the Niagara Falls (I swear, I saw them!).
With an extra you can go up of 100 meters (450 meters total) but the queue it's VERY long, so I suggest to enjoy the "lower" floor.
If you don't have vertigo go outside in the terrace all around the tower and breath the fresh air, or just step on the plexiglass floor and watch your foot over the very small cars and persons 350 meters down of you. Fantastic!