We spent a few days touring Niagara Falls the first week of July. We visited Marine Land, we stayed at a hotel downtown that was connected to the Fallsview Inn Waterpark which was fantastic (and much more age appropriate for our kids). We had a blast touring downtown, seeing the falls, dining at Rainforest Cafe, watching a movie in the courtyard at our hotel and of course the boys loved spending a night in the hotel.
