After ordering 2 (clone) AI Thinker ESP32 CAM modules, I got one of them running a week ago using ESPHOME. But after almost a week this module stopped working telling me it could not find the camera module anymore. Replacing the camera module did not solve this. Flashing the other module with the same image did not work either. So I had two modules now both not working.
Today i found out that these modules have very bad soldering of the ESP32 module near the connector pins. It looks like they soldered on the pins first before soldering the ESP32. As the ESP32 heats up, these connections get unreliable.
After resoldering these connections, both camera’s are working again with ESPHOME.