I won't lie - Niagara Falls, the town, is a shit hole, and I hope never to return there. The falls are genuinely not worth the disgust you experience walking through the town. That said, here's a photograph of what you'd see if you were able to ignore everything else. This is not what you will see if you go there.
I found the US falls more interesting than the Canadian falls. Because it's not a crescent, there is no giant cloud of mist that obstructs the view - it's just a rather big waterfall, and quite nice to see.
The Canadian falls are crescent, and form a ginormous mist cloud because the vapour can't disperse.
It MIGHT be impressive if you could walk down and look at it from below, but idiotic over-commercialisation ensures you can't without buying a boat tour, which -incidentally- completely ruins the view.
Well done, Niagara.