Thanks so much for the advice all. I think I will stay at Niagra a night. I would like to see the lights on the falls at night and as my stay will include a Sunday I believe there will be fireworks.
Can anyone advise which hotel has the most spectacular room view of the falls? I'm leaning towards the Marriott or Embassy Suites at the moment.