Anything for you, Jason.
Now, I'm no Canadian and I haven't been there since I was little so I will do my best at remembering stuff here.
Located right on the border of Niagara Falls, New York, Niagara Falls, Ontario is quite a hotspot for tourists. With 4 waterfalls (Niagara Falls, Horseshoe Falls, Bridal Veil Falls, and American Falls) that can be viewed from either border on land or by a tour boat like the Maid of the Mist or paths that take you up close and personal (some even behind the falls!) there is truly a wow factor here in this city. At night they light the Falls in a rainbow of color that switches up for quite the beautiful light show.
Picture of the falls lit up at night:
http://fc09.deviantart.net/fs26/i/2008/117/5/b/Niagara_Falls_Night_by_PrimalOrB.jpg
One of the paths you can take:
http://upload.wikimedia.org/wikipedia/commons/1/12/Cave_of_the_Winds_at_Niagara_Falls_IMG_1366.JPG
http://upload.wikimedia.org/wikipedia/commons/b/b9/Cave_Of_the_Winds_Niagara.jpg
Apart from the falls we have things to do during the day like the Guinness World Records Museum, House of Frankenstein, Louis Tussaud's Waxworks, MGM Studio Experience, National Helicopters (helicopter rides around the Falls), Niagara Go-Karts, Niagara SkyWheel, Ripley's Believe It Or Not, African Lion Safari, Fallsview Indoor Waterpark, Marineland of Canada, and so much more fun for families!
What you could see from a Helicopter ride:
http://upload.wikimedia.org/wikipedia/commons/3/3b/Horseshoe_Falls_from_helicopter.jpg
Night life is also big here, there's Casinos along with clubs with views of the falls for the people of age . It's a very hip and happening place.
Restaurants are pretty affordable compared to Hawaii. The Skylon Tower is probably one of the most notable places to eat as it's a tower that rotates 360 degrees (very slowly so you won't get sick, I might add) for a stunning view of the falls. There's also a Hard Rock there among other well known restaurants for all budgets.
The Skylon Tower:
http://upload.wikimedia.org/wikipedia/commons/7/74/Ilievaart-falls0805_7584smaller.jpg
As for hotels there's a Hilton right on the falls and from a bit of research rooms are fairly affordable going as low as $129 a night (though room rates to vary day to day). Obviously, prices will vary season to season, but I feel like it's a good indicator either way. There are lots of other hotels really close to the Hilton even.
The Hilton:
http://www.statesman.com/multimedia/dynamic/00147/NIAGARA-FALLS-0117T_147830c.jpg
Transportation wise I remember most things being in walking distance of the hotel my family stayed in which was nice.
The falls are located 17 miles (27 km) north-northwest of Buffalo, New York so there's the option of staying on the US side if that floats your boat. Plenty of border hopping to be done with touristy things all over.
Hopefully this is enough information for you, Jason. Let me know if you need anything else and I'll add it in when I wake up.