Great view of the falls if you ask for a falls view room. Some of the rooms are seen as a falls view even if the are the side of the hotel, if you can see the falls. If this is important to you, ask for a room on the front of the hotel facing the falls. On busy weekends the rooms can be ready late - I only got my room at 16:15. If you want to make sure you get a room when you get there, phone ahead and specify that you need your room ready early. Rooms need a revamp, however service is generally very good.
Update: there was a mistake on my bill. I pointed this out and it took more than 10 minutes for the person at reception to understand how to resolve this. Eventually she said that because it was a Saturday, the finance department was not available, it would reverse the charge on Monday. This did not happen. I had to follow up. Then the bill mistake transaction was sent to me, which was clearly a different name and billed to my room before I checked in. I then had to follow up again and ask for it to be taken off my bill. Sorry, Sheraton, you have moved down in my rating for making me do the admin around your mistake.