Well, I don't shoot a Sony camera, but I have dove in Cozumel. I think a lot depends on what you aim to do.
1.) I liked the underwater topography, particularly the Palancar sites, enjoyed the variety.
2.) I liked the marine life - thought it was pretty fishy and had a decent amount of fairly big animals - black grouper, nurse sharks, green moray eels, eagle rays, etc... That said, I was impressed with the fishiness of Key Largo back in 2013. A lot may depend on what you compare Cozumel to.
3.) Drift diving I can take or leave. It can be fun to ride the current, or frustrating to pace the guide who's drifting at a different rate (I was a bit shallower, granted, which may've been causative).
4.) I mainly take snap shots of medium or large creatures with a point & shoot camera. I don't carefully compose photos of macro subjects, change lenses or filters, set custom white balance, use manual mode or otherwise do much 'fussing' with my rig (other than switch flash mode from 'Off' to 'On' and back).
I'd suggest do multiple dives across multiple sites, enjoy Cozumel for what it is, and consider what your diving and photography goals are. Do you like hovering over a coral head carefully composing macro shots of nudibranchs? Or waiting for the yellow-headed jawfish with the mouthful of eggs to pop up and pose?
What other destinations have you been to compare it to?