Been there a few times. Love the diving and the dive op; hate the hotel--overdone with inescapable and tortured promotions of their side businesses and the noise of their horrible events.
Unless it's changed; from mid-week one, they'll blast music (including horrific amplified kareoke) in the court yard in front the rooms so that you won't be able to even hear the tv in rooms much less sleep. There is no escaping this failure in basic hospitality.
Search this site for condos of better places to stay on Little Cayman. Either that or try to get the rooms across the road in the bird refuge.
Aside from the dumpy resort, the dive op and diving are as good as you'll see anywhere.