We went on an excursion to Rio Secreto during our Oasis of the Seas cruise to Cozumel and it was really amazing. It was about an hour traversing water in a cenote (about a mile and a half). The water wasn’t too deep, but there were several areas that were very, very, very tight. You can read the detailed account here.