We only splurged for a good hotel twice on the way out, and this was one of those times (the other being in Des Moins).
I feel that if you are going to Niagra, you should get a place that let's you really experience Niagra. It doesn't make sense to spend money to get there and then cheap out on a motel 6 in a cornfield.
Now, not only did we go to a good place, but we lucked out, in that they ran out of our room type and put us up in a more expensive suite at no extra cost. The room included a bedroom, kitchen, living room, and jacuzzi. And mst importantly, the room included a gorgeous view across the falls.
More daytime views.