Let me be clear. I absolutely hate the crowds, the lines etc. of tourist trap places. The only reason i consented to go to Niagara was because it was a Toronto/Niagara family trip with my in-laws. I still had my "roll my eye" mentality all the way to getting on the Maid of the Mist boat.
But then it started moving and you realize how awesome the experience is. Though the falls themselves seem so much bigger on tv, really, Niagara (the Canada side) is beautiful. I'm so glad we went. If we get around there again I'd stay in Niagara on the Lake. Take another ice winery tour too!
Definitely stay away from the Skylon tower. In my opinion, it's WAY overrated.