Having been to both Little Cayman and Bonaire, I guess I'm the odd one out here. I would go to Bonaire hands down before going to Little Cayman again. One of the posters above commented on the fact that all the dive sites on Bonaire are basically the same. I'm not sure which sites he dove, but I could not disagree more. The dive sites vary considerably from one end of the island to the other. During my trip to Little Cayman last year, the vis was ok, not the best. On several of the dive sites there appeared to be some sort of yellow cloud in the water, hopefully not pollution from the resorts but it could have been. The thing that I noticed most was the lack of sea life compared to Bonaire..
I had read many posts talking about how excellent the diving is in the Caymans. I was totally dissapointed in the diving on the Brac. The reefs are not healthy, lack of fish, and the dive operation was less than acceptable. little Cayman was certainly better than the Brac but still not what I would consider the best diving in the Carib.
Having just returned from Bonaire this past Sunday, I can tell you that the diving was incredible. The vis was the best that I have seen in the Carib in the last several years. The abundance of sea life was remarkable and they topside businesses have really improved over the last several years.
Not to mention that it is way cheaper to go to Bonaire than to Little Cayman.
PM