First off, the pros:

First off, the pros:
We were able to check in early (12:30 pm) because it was off peak season and they seemed to be pretty slow. Even if we couldn't check in early, you are able to use the water park starting at noon of your check in day, plus you get to use it the full day of your check out day as well.
The water park itself was decent. If you aren't local to Niagara Falls, it's cheaper to get The Groupon.
The cons:
The room smelled pretty bad. Not quite bad enough to complain to the front desk. Just musty, a little sweaty, like it needed to be aired out. Not leaving the AC on didn't help it either. The AC didn't cool the room down by much. It was still pretty warm even after running the AC all day and night. Even I was warm, and I am constantly cold!
Wristbands. Do NOT lose them! It's a $25 charge to replace it. But, if it gets damaged, do NOT throw it away! Instead, bring it to the front desk and they will replace it for free.
They don't offer shampoo or conditioner in the rooms. Only hand soap. From a dispenser. Even in the shower. It definitely cheapened the entire feel of the resort.