No, I'd say the park pretty much sucks. This is the extent of their waterpark:
There was a lazy river and some other crap if I remember, but nonetheless it was small and IMHO not worth your time. I've actually been to the park twice. One day it was empty and I was able to do the park in half a day, but the other time I went I used the after-5 deal and did maybe half the park (though I did ride the Comet about 10 times that day). You could use the after 5 deal but bewarned.
Oh yea, eat their pizza. It was pretty good and somewhat cheap.
If you are looking for a good waterpark in the area, Darien Lake had a pretty nice one :-)