I suppose when you come to Toronto as a visitor, going to the top of the CN Tower gets on your list. The night before we had dinner at Canoe which also boasts great views, albeit not so high, and terrific food.
Bottom line: It is fun but expensive for moderate food. No surprise.
If you go to see tower without dinner it will cost you $30 but free if you have dinner. You'll also cut the long lines.
The service was very friendly. The restaurant rotates once about every 72 minutes. We made it around a few times. You get good views of the city and lake. We found ourselves surrounded by annoying kids and crying babies. I guess that's what you get at a tourist spot.
The food was just okay for what you pay, $300 for the two of us including tip. The bread is pedestrian and accompanied by cold butter. The trio of seafood appetizer is flavorless. The Caesar with bacon was drowning. The lamb with harissa was really fatty and not spicy as I would expect. And so on.
After dinner we went downstairs to the viewing platform, stood on the vertigo-inducing glass floor.
If I were to do it again, I'd go for dinner and limit my food purchases, have a few drinks, and get the view.