The water around Grand Cayman really is this blue - partly because is so deep around the island (which is allegedly wider at sea-level than it is at the base on the ocean floor!).
On the North shore it drops pretty sheer straight down 6,000 feet. Which is part of what makes it the world's best dive site. Although you probably need to get your buoyancy right before you swim over the Edge. . .