We stayed at the Sheraton on the Falls at the end of October - booked a Fallsview room - well worth the extra money - breathtaking views of the whole of the falls during the day - both the USA and Canadian sides. Also good views of the fireworks on Friday night. Lovely room too - interiors are a little tired but who cares when you have this sort of view!
Can also recommend the Best of Niagara Falls Tour trip we took with See Sight Tours (booked with Viator before we left) - excellent guide in Carwen - extremely friendly and helpful + we saw all the things we wanted to see but the boat trip was the icing on the cake - a must do if you are staying or visiting. Getting up close to the actual Falls is mind-blowing and you also get very wet as the ponchos only cover half of your arms and only half of your legs! but to miss it would have been criminal. There is a plexiglass screen you can hide behind if you don't want to be soaked, like me!
All in all, an excellent visit - if you can, go midweek as weekends are really busy.More