I spent $1,000 to stay in a hotel directly facing Niagara Falls. The room surprised me in 4 ways. I stayed at the Sheraton Fallsview in Niagara Falls. My room had a door that opened to the sound of crashing water and a view of nightly fireworks.