I've got the cheapest USB webcam money can buy plugged into my octopi. It's attached to the desk behind the printer, pointed at the bed. It's about good enough to see if the print has suffered catastrophic failure, and not much else.
Your image is brilliant, though. If I had something like that set up, I think I'd print garbage all day just to watch it go.
Mine is a simple PiCam attached to the X servo motor so it travels up and down with the gantry running through Klipper/MainsailOS. The image quality isn't great but good enough for the task. Some additional lighting would certainly help things out.
One bonus feature is that I've connected Mainsail to HomeAssistant so I can monitor and control the printer from anywhere with internet access.
I did a nozzle cam setup with a cheap borescope out of eBay once, and definitely loved watching that first layer. Eventually it gave in to the heat and I haven't bothered to replace yet though. Also multiple cameras on octopi was a bit of a pain to set up when I did it, but that was 2-3 years ago
I have several cheap USB website and they work fine but my best cam is probably the Luke's lab USB cam I bought, it has or LEDs so it can see in the dark. I had issues with the atlas they provide for the camera case but the image from it is decent in any light which is real good.
You could put a sodium vapor lamp directly over it and it would still be bad. It's the framerate. The main board is what caps it. It's essentially fine for It's intended use of letting you see if you're making spaghetti, but that's about it