Hello, Ironborn.
We have shore dived the West end of Curacao three (2 wk) trips with another 2 wk+ trip planned in Feb 2018. We (also) stay at Marazul, in Westpunt. The drive from the airport eats up time (seems like 1/2 day), so we buy groceries upon arrival before our drive out to Marazul, & then only 1 other trip to Centrum near the airport, early in the second week. Lots of sandwiches & simple fruit during our shore diving SIs lunches stretch the groceries (simple fare). An “arrival” pre-order of food items purchased for you, to bide you a few days makes great sense, if your lodging will provide this service - we have done this.
IMO the coral is exceedingly lush just off the drop off of Playa Kalki/Go West home reef, Playa Picado/local fishing dock reef (my image), Marazul’s home reef, & Playa Forti - they are lovely. Perhaps large fish aren’t exceedingly abundant, but perhaps a slower pace would reveal the “hidden” smaller marine life. We see plenty of life overall (squid, octopus, frog fish, eels, various rays, turtles, + the “usuals”), but - yes - it IS different than Cozumel, which is lovely in its own regard.
We also enjoy Bonaire (alternating years w Curacao) for its similarity & differences (lovely & easier to navigate shore diving sand beaches in Curacao). But Curaçao is a much larger island than Bonaire making diving “best/favorite” dive sites more problematic/time consuming requiring good planning & again some transportation. And, we actually think the double reef of Port O’Marie IS lush & lovely - worth diving every trip. I cannot imagine staying on the west end of Curacao without a car. We plan & drive around the west end to cover the sites we wish to dive, daily.
If I had no transportation, I think I would select Cozumel with a dive resort with boat dives within walking distance from town, or go to Bonaire & do the same. Curaçao almost requires more time (for transportation) with stays at either end of the island & a guide (at either end) with a car or boat.
I haven’t been to Little Cayman Dive Resort, but shore diving Cayman Brac is worthwhile for diversity (without a car you’d want to stay & boat dive with either the Brac Reef resort, or some other lodgings that work with the Brac Shack dive shop. Just 2 dive shops on Brac), although neither may have the nite life you are looking for.
I missed when your trip is planned - good luck! Diving ANYWHERE, is better than staying at home.