I highly recommend taking a trip to the falls if you ever can. It's a unique experience that no photo or video can truly capture. Visit both the American and Canadian sides if you're able.
The Canadian side is mostly a shitty tourist trap and a lame casino, but it's definitely worth a day trip to see the falls. The Hornblower boat trip (Canadian Maid of the Mist) and the tunnels behind the falls are really cool, although a bit pricey.
Definitely recommend staying at one of the BnBs at Niagara on the Lake and popping over to Niagara falls for a day, because staying in Niagara Falls sucks. There's one BnB I stayed at a while ago called "The Tea Cosy" I think, if it's still around that place was great. Owners are a super sweet older couple and the breakfast was delicious.
It's the noise and the scale that really drives the experience home, the sheer volume of water coming through there is immense. Well worth a visit for sure. Although yeah do agree that the other side is better for viewing if you have the option!