We stayed at the Hilton on the Canadian side...it's fairly new, only open 2 years now, I believe.
I have pictures of the hotel and other Niagara Falls attractions on my "family web site", the link is below.
Just recently someone else was asking about Niagara Falls....I listed some web sites I used when researching our trip. Let me know if you'd like me to post them.
We stayed at the Marriot Renaissance Fallsview once. We had a room with a spectacular view of the falls. A bit pricey, but it was a nice place to stay.
We have stayed at the Hampton Inn a couple of times. Nice place and you are able to walk to the falls. You can't see the falls from the hotel, but you can walk to them without a problem.