When we've been to Niagara Falls we were quite cheesed off by the touristy atmosphere. The Niagara Falls, ON station is linked to the falls by the WEGO buses.
http://www.niagaraparks.com/wego/ The falls itself are quite impressive, though.
However, don't miss the craft brewery, close to the...