Regarding not finding any projects using ROS and ESP32-CAM module, I spoke too early. I found this project here that does exactly that. Also this one from the same author that is even closer to what I want to do, but it doesn’t have any code right now and is still ROS1.
It is using the sensor_msgs/CompressedImage instead of sensor_msgs/Image topic, probably for performance reasons.