I've been to Anguilla and St Martin, and the water was crystal clear in both places.
I've also been to Acapulco, and the water was very 'blue', and not clear at all.
For my next vacation, I'm deciding between Cancun and Punta Cana.
Will the water be clear in either place? Murky? Comparable to Anguilla & St Martin?