I’m answering this before reading your entire thread, so forgive me if I repeat something already said.
If you are talking about recreational dives on a dive boat filled with recreational, single tank divers, then just use single tanks like everyone else. It’s MUCH more convenient. Of course there are always people on the internet that will say it’s fine using doubles (SM is double tanks) on single tank dives, but in the real world it’s a pain for yourself and the operators of the boat.
If you love the cenotes (who doesn’t!) then learn sidemount for that environment, and practice your sidemount skills in cenotes and OW shore dives. That’s exactly what I did. On the occasion where I do some rec diving, typically in Cozumel while on a cave trip, I use a single tank on my back just like everyone else. In cave diving, which is the vast majority of my diving, I use SM and stages.
When I did ANDP, I did a few SM dives off a small boat. But those were deco dives, on a boat with tech divers and crew, with stages. And it was not easy to gear up and get everything sorted, and that’s with years of experience diving SM in caves. So….not ideal.
You mentioned currents in SM vs single tank. For sure you are less mobile and more affected by currents in double tanks. You have a bigger profile, even though SM is about as streamlined as you can get with 2 tanks, and quite a bit more mass to move around.
Divers use SM in caves because: 1) double tanks are required, and 2) the cave environment often favors the profile and flexibility of SM, and 3) it’s very convenient to gear up in the water. None of those things apply to single tank recreational diving off a boat.