I have been to Little Cayman Beach Resort twice. The rooms are good. We stayed in rooms with 2 queen beds, bathroom, and a little sink, microwave, coffee maker and sink area.
You get three meals per day served buffet style (there are special order omelets). The food is quite good as long as you are a bit catholic in your tastes. Fussy people can find fault with almost anything.
The dive boats are 42' newtons with a 20 diver capacity. I have never seen a boat crowded. People get up on the top deck or the bow area so even with a full boat, you never feel crowded. You leave your BC and regs on the boat. You take your mask, fins, and wet suit to the drying shed. You dip them in the tanks and hang things up in the shed. You can take some gear to your room and put it out in the morning. The staff will take it down to the boat or you can take it yourself.
Typically there are 2 morning dives: at 110' max for 50 minutes followed by a 40 minute surface interval and a 60' max for 60 minutes. The afternoon dive is 60' max for 60 minutes. Sometimes they do a night or dusk dive (Tuesday, Wednesday and Thursday sign ups and weather permitting).
Both times I have gone have been in August. It is early hurricane season but so far I have done fine.
There is really nothing else on the island. There is a little general and liquor store which has not much. There is a restaurant called the Hungry Iguana. I have seen it and not been in. It does not look horribly inviting.
Meals are at 7 AM, 12:30 AM and 6:30 PM. People gather at the little bar by the pool and chat. It is pleasant. The drinks are fine and the ambiance is good. There are local iguanas hanging out on the board walks. They will readily eat fruit. You will see frigate birds and albatrosses.
There is a small pool and a jacuzzi. You can take kayaks out if you so desire or walk on the beach.
The dive staff is superb. Also, Craig is a divemaster and photographer. He is very good & knowledgeable and will give lessons for a price.
The whole staff is cheerful and helpful. The diving is excellent.
The Tibbets family saw that diving was going to be the big money maker. Many places in the Carribean have marine parks but the locals often fish them relentlessly. Little Cayman actually enforces the rules strictly. The turtles you see pretty much ignore divers. The nassau groupers are often tame and will see if the divers will pet them. My wife had groupers following her all over the place. She would swim a few feet. Her grouper would head butt her. She would scratch under its chin and swim a bit. The cycle would repeat. I was taking photos. Groupers would often swim between me and my subject. So I would scratch them and then gently push them out of the shot.