I’ll add this thread for something that uses an espcam to do motion detection. MQTT Motion Detection using ESP32 Camera (no PIR) - but does not provide a camera entity in HA.
Also motion detection is, I believe, possible with esphome esp32camera when combined with motion or motioneye.