Give Peninsulair a call at Hamilton airport, and see if you can get an airplane trip over Niagara falls. I did it a few years back, with me flying the plane. Bloody awesome.
Might be different in winter, but in summer it's pretty quiet at the weekends as it's very much a business city and a lot of locals go off to their cabin for the weekend. Shops etc are mainly shut on Sunday.