The water in Cabo is not as clear as in many of the Caribbean ports, that is true, but it is still decent. Looky here:

As far as currents, you can have that anywhere - Cozumel is a good example of somewhere you can get in big trouble really quickly due to the currents.
I haven't been to any of the other ports yet. Last time I tried, I ended up having to go to Canada due to some flying pigs or somesuch.
~ MattInSoCal
Proud member of the short .sig club.