Best camera hardware supported by ESPHome?

Looking through the various ESP32 boards with cameras supported by ESPHome, I’m wondering if anyone has any recommendations: I’m looking for a reliable, relatively hi-res camera, ideally with live video capability and a high frame rate. I’ve enjoyed using a few of the TTGO camera modules but they are low-quality and prone to overheat.

Other notes: These will be wifi and wired to power, no need for battery. The use case is: Motioneye is less and less supported, and I’d like to replace my RPi units running Motioneye (complicated, UNIX FS) with ESPHome units (uncomplicated, easy to update). Ideally looking for a single board, camera included solution.

What’s the best bet in April 2022?