Are there any good lenses out there that don't cost a lot?

I could not find any good demo videos from the Rpi HQ camera. There are either macro shots showing the background blur, or some terrible medium range ones.

If a good lens costs an arm and a leg, it is probably still cheaper to buy used entry level mirrorless camera, and it will also have autofocus.

I really wish there were better webcams and I would not have to result some bulky mirrorless/dslr or iphone with droidcam.