I've not set foot on CC for many years, but I dove there as recently as 6 years ago. The trip to CC from the nearest hop off point is a long boat ride, maybe 2+ hours from a mainland Honduras point.
The island is muy primitivo, and unfortunately this does have an effect on the diving. The infrastructure is not as built up and reliable as Roatan, Guanaja or even Utila. The closest similar Bay Island that maintains a dive op base is Barbaretta.
There are sea mounts nearby that are usualy out of the breezes that may blow. Quite a treat when divable.
Diving at Cayos Cochinos? Not for the Casual Cozumel Caroser, but if you have some Indiana Jones left in you, knock yourself out.
I'm sure that others here have had more recent and more valuable experiences to relate. If you have the energy for it, by all means, go do it. How many can say they have?
You'll be able to paprphrase my line in a few years, "Let me tell you about Cayman in 1970..."