I paid $1,000 for 2 nights in a hotel room facing Niagara Falls. It was totally worth it.

I booked a room at the Sheraton Fallsview Hotel in Ontario, Canada. For $500 a night, I had an epic view of Niagara Falls and nightly fireworks.