I have a Logitech C920 and am looking to upgrade. Something suitable for streaming.
Some annoyances with the Logitech: sometimes autofocus fails and poor reproduction of blacks. Ex: Lack of detail when a black cat is on screen.
I already have a nice mic-- the webcam doesn’t need one.
I’m using a Sony ZV-1 in a SmallRig camera cage, attached to an HDMI capture device. It’s a step below a DSLR, also in price, but it makes a huge difference to the quality and I get frequent comments about the “AWMAHGAWD amazing set up you’ve got, looked at how crisp it is” when I join meetings. The lens is really open and it captures a lot of detail. By far the best compact/quality setup I’ve found.
https://imgur.com/a/RXVuqit