I got one of those Sony IMX sensor based HD Usb cameras. Gives a resolution 3264x2448. Streaming with a Raspberry PI 3 gives about 0.3fps at that resolution. However it does only claim a 30fps rate at stupid low res. So, nice sensor, nice price, either rubbish processor or the PI can't actually handle that bit rate, not worked it out.
https://www.amazon.co.uk/Magepixel-Varifocal-Webcamera-Difinition-Industrial/dp/B08JTS9KB2/The lens is all sorts of weird. It says 5mm to 50mm, but that's entirely fictional. It seems it's closest focus distance is about 0.25m, but no where near as wide as a 5mm lens. This might be that I need to first normalize the focal length with the sensor size, but to me it looks more like a 30mm to a 150mm lense.
I can't give you much input on overall quality, because I immediately put it into service watching the pepper seedlings. So it's about the worst possible scenario for one of those cameras. A high red+blue spiked 'white spectrum' 30W LED light. Shiny metal reflective background. Opened in a photo editor the spectal curve shows the massive spikes, but also some more disturbing bouncing in the lower red spectrum. Again, it not exactly the best environment and I should really take it out in bright sunlight and see what it can do.
As a camera intended to just keep an eye on things, I think it works far, far, far, better than any cheap (or expensive) webcam for the purpose. Not "cheap" cheap at £80 UK, but you can get the bareboards + microlens, maker style boards for about £35.