Not being one to take such challenges lying down, [Bitluni] has come up with a nice programming board for the ESP32-CAM that you might want to check out. The problem stems from the lack of a USB ...

But if you’ve run out of camera modules, webcams, or IP cameras, you can incorporate an ESP32-CAM board into your Raspberry ... as it lets you program the microcontroller from a web UI.

This ESP32-CAM surveillance bot is a great example of ... out how to get a microcontroller to talk to a small camera module. Only then could you consider solving the multitude of other problems ...