drrich2
Contributor
I can deal with current if I can just hunker down and breath calmly and get lost in the hunt for macros.
If you're a macro enthusiast, you might be in for some frustration in some settings, like what I'd call mainstream Caribbean scuba day boats that cater to a lot of occasional divers who may have a greater interest in reef topography and scanning large areas of reef for larger creatures (e.g.: green moray eel, black grouper, eagle ray or octopus). Some say slow down and you'll see more, but some of these people wouldn't be all that impressed if you did show them a tiny blenny or inch long nudibranch.
Just as you may feel ripped off by a superficial scan of a large area, imagine somebody wanting to see a whole dive site who didn't travel over 50 feet out the whole dive. Everyone comes to the boat with a personal agenda that is important to them.
Others gave a good range of suggestions; advance discussion with the boat to determine their 'dive culture/style,' finding an op. that'll let you and a compatible dive buddy dive separate from the group (or let you use a private guide, likely at an added charge), and of course a few might let you solo separately from the group though that's not as common. Independently shore diving is your friend; Bonaire and Curacao bit time, perhaps St. Croix, and with a buddy Grand Cayman is an option.
The environment you choose will also be a factor. A drift dive destination won't lend itself to prolonged hovering over a single coral head.