Tried out the ZeroCam recently for a Raspberry Pi Zero 2 W webcam project—and honestly, it’s spot on for what I needed. Tiny footprint, so it doesn’t bulk up your build, and it plugs directly into the camera port.
Image quality is decent for such a small module, and it works straight out of the box. Perfect if you're trying to keep your project compact.