I've done some of the dives listed here:
http://www.scubaboard.com/forums/ag...n-aggressor-iv-captains-logs.html#post6599767 so if your trip is similar, here's what I'd consider the highlights. We stayed on Grand Cayman but it's the same sites.
Trinity Caves is an excellent dive - one of the best in the NW Point area. Big Tunnels is another - long deep swim-thru. Watch for Turtles shallow, when they get disturbed they hover around till you leave. We had a couple cruising near us during our entire safety stop. Orange Canyon would be another to ask about.
Babylon is slightly farther east. I could make a case for it being one of the
best dives off Grand Cayman. My buddy dove it this past January and they were trailed on several dives by a couple of reef sharks looking for a Lionfish snack. He turned once and almost kicked one in the head. Other divers earlier in the week saw a big Hammerhead there also. The drop off the North Wall there is stunning - you strain your eyes to see things 3-400' down the wall. It goes to 6,000' in that area.
Ghost Mountain is another possibility in that area - equally as good. Less likely unless conditions are excellent. Eagle Ray Pass (not Rock) or Hammerhead Hill would be others to ask about. These 4 dives are more likely to be blown out in the winter - my buddy was land based at the East End and it took them three tries to get to Babylon.
Aggressor is doing both the Kittiwake and the Poulson wrecks also. CITA dropped the Kittiwake near the Sand Chute dive site - it's different, kind of a steep drop-off of sand not reef. Interesting dive - something you don't see every time off Cayman. I think you could do both in one dive but IDK. I haven't dove the Poulson but it was "the" wreck pre-Kittiwake. Since Kittiwake was prepped for diving, it's very accessible to all levels of divers.
And Sting Ray City is highly entertaining - the other signature Cayman dive.
If the Aquarium site they mention is the one I know off the West side, it's one of the better shallow dives. Big coral patches with sandy areas between them. Several have fluorescent Coral Shrimp at cleaning stations - look for fish hovering just off the reef. My buddy had his cuticles trimmed by one - just slowly hold your hand out and they'll climb on. They didn't like me...
The last dive - Devils Grotto - is right in downtown Georgetown so sees a lot of cruise divers. It's swim-thru's with a few Tarpon lingering around. It's epic in the summer when the Silversides are there but that's only in July/August - won't be the highlight of your trip. But doesn't exceed 40' or so if you're near no-fly limits - it seems to be their last dive. Considering that the dock is about 100 yds. away I can see why.
You can see HD video of a lot of the sites they mention here:
Welcome To iDive! | iDive
Hopefully you can make the run over to one of the Sister Islands. Diving is better off Little Cayman - Bloody Bay Wall is one of the best in the world. No personal experience but it's on my bucket list. Check this out:
The Bloody Bay Wall Mural Project
hth,