Missing ports and excursions is a too-common event if you pin your vacation on those visits.
I had Passion Island booked, but arrived in Cozumel to find it cancelled - due to a possible storm in the afternoon and its potential affect on our return boat ride.
And Cozumel was the only port on that cruise. I was able to find a different excursion for the day - and my pick of Passion Island was just part of my ongoing search for something to do in Cozumel.
@ramee - also look into Paradise Beach Club, Mr Sancho’s, or Nachi Cocom Beach Clubs in Cozumel. These are reached by taxi, so less affected by stormy seas. They are mainly all-inclusive, some offer the choice of no food package. Loungers, shade, pools, water craft are possible inclusions. I’ve seen my usual travel vloggers visit all of them. They have different vibes; one is a little louder than I like, others are more mellow than others would pick.
Grand Cayman’s reliance on tenders (and maybe its geographical location?) does seem to get missed due to rough seas.