If you sign up to do some cavern tours of the cenotes, then you probably won't be given a choice of dive site, but here are some nice spots:
- Cenote Chac Mool - lovely wide cavern opening with interesting boulders
- Cenote Garden of Eden - lots of cenote fish (sailfin molly)
- Cenote Taj Mahal - stunning rays of light beaming down into the dark cavern zone (any "rays of light" sites are time of year-dependent as it will change with the timing and angle of sun overhead)
- Cenote Pit - rays of light
- Cenote Pet Cemetary - bones
- Cenote Angelita - layer of hydrogen sulfide penetrated by fallen trees
- Cenote Car Wash - half the year has a dense green algal bloom across the top, lily pads, lovely big cavern entrance
The number of dive sites and photographic opportunities are much greater than that listed above. Cenote Dos Ojos is probably one of the most popular cavern tours but I haven't mentioned it mainly because I think it's a bit too chaotic and they charge for camera access. But it's a zoo for a reason - it's a great dive!
If you dive with an operator from the Cancun area, then I would think you are quite likely to go to places like Chac Mool, Eden, Taj Mahal and Chiken-Ha because they are closest. If you were to select an operator in Tulum then I think you would have a greater chance of visiting Grand Cenote, Temple of Doom and Angelita due to proximity.
I should qualify that I'm a cave diver, so my time in the Riviera Maya is spent doing self-guided cave diving, not doing cavern tours.
This page on my website has cenote-style photos from Angelita and Grand Cenote to give you an idea of photo opportunities: