Definately make the trip. I am a tour guide with overthefallstours.com. and we work out of the econolodge at the falls, on Niagara Falls Blvd.
The best way to see the falls is with a guided tour. We take you to all of the attractions and little hideouts that you would never see on your own. If tours are not your thing then heres what I suggest you do on your own, all accessible:
The only thing I would suggest is to do the Maid of the Mist trip from the United states side as there is less walking. It is offered from both the Canadian side and the American side. Made sure it is operating when you come as the start time for this attraction is always different depending on the ice from the Niagara river. Usually runs April-late Oct.
You can drive to many attractions on the canadian side, the majority are free parking. My favourite is the whitewater walk.
You take an elevator down into the gorge and walk on a wooden walkway as far as you feel you can alongside a class 6 rapid. It is beautiful. Just down the road is the areocar ride which takes you across the whirlpool in a cable car, no walking
involved. 10.00 canadian for 10 min
The butterfly conservatory is small with 2000 butterflies flying around and that is located within the botanical gardens. This is all on the same river rd on the canadian side. Continue down this road to Niagara on the lake to complete your day.
Morning walks around goat island on the us side is beautiful. You are guareented to see a rainbow overlooking the Canadian horseshoe falls whenever it is sunny.
You need 2 days here at least.
Hope this helps
over the falls tours