We have stayed at Hard Rock, Animal Kingdom, Swan/Dolphin, Sheraton Safari and the Radisson Celebration They all have nice waterslides, but the issue becomes supervision. At Disney and hard rock the supervision is excellent they sit at the bottom and the top and monitor children and they keep kids out of the hot tubs unless they are with an adult.
At the other hotels, you really have to pay attention because older kids start skipping in line or going down too soon and landing on your child's head! Or they get in the slide and hold on to the side just to make everyone wait!
(this happened on my last trip to the Sheraton)
At Sheraton it can get rowdy and crowded and the guys that sell suntan lotion TRY to monitor the waterslide. (no one at the top and bottom) but basically kids are on their own with parents paying NO attention. I especially loved the boys that did cannonballs in the hot tub with ME in it.......