Nope, just got open water certified. Basically trying to estimate which skills I would need/hours needed, before it makes sense to buy one.
You need good technical finning techniques - frog kicks, helicopter turns, and back kicks.
You need to be proficient and completely comfortable with basics like swapping regs and clearing your mask.
If you're going to be diving dry, you need to be completely proficient with diving in a drysuit on OC.
You would be well served to get good at u/w photography on OC first. Being an experienced land-based photographer is only moderately helpful. Underwater photography is its own beast. The Martin Edge book, The Underwater Photographer, is an excellent one to read to help you get started there.
From there, I will break from what others have said and say that, if you have those skills at a reasonably high level of proficiency, you could reasonably start on CCR training. My opinion is 50 dives could be enough, if you actually work at the skills. If you just go diving and don't pay any attention to actually working on the skills, then it will take longer. Potentially, a lot longer.
As has already been observed, learning to dive a CCR is like learning to dive all over again. Buoyancy is completely different. So, what advantage is there to waiting (once you do have the skills you need)?
Your first cert would be for 100', on air (for dil), with no decompression (at least, with TDI, but I think most other agencies as well). That should be all you need for the dives you described. You can stay at 40' for the duration of your scrubber or O2 cylinder (i.e. anywhere from 4 to 8 hours) without incurring a decompression obligation.
Once you do get onto a CCR, plan on logging enough hours to get some basic proficiency with it before you take a camera in the water with you. When I did my initial CCR training, my instructor told me if I spent 30 - 35 hours diving it in shallow water (say, 40 feet or less) and swimming around, including going up and down over things, going between shallower and deeper parts and so forth, that should bring my buoyancy skills on CCR to a fairly proficient point. That worked out for me and I started diving with my camera again after that (with no issues).