I think the best vis is going to be out in blue water with no bottom and sharks, mahi mahi, dolphin, wahoo, whales, mantas, and other pelagic fishes swimming around. The vis is always good regardless of weather because there is no runoff, no churned up storm mass, and flocculants tend to settle out of the water. Blue Water diving is amazing.
What comes close is those places like seamounts where the bottom doesn't quite break the surface. The Flower Gardens meets this criteria, but it isn't guaranteed because of river outflow into the Gulf of Mexico. There are seamounts in a lot of places like Chinchorro bank, Silver bank, Alacranes reef, and others throughout the Caribbean. These coral outcrops occur throughout the world, but getting there is a bit of a pain. You might check with a surfing liveaboard. They go to these places for surfers.