1: https://www.alliedvision.com/en/products/camera-series/alviu...
So you're stuck with the little optics included with the tiny hobby cameras from Pi or ArduCam (et all). They're okay for some purposes but a lot worse than even a cheap SLR/Mirrorless lens.
The best results I've gotten are with the C-mount camera module, an adapter, and a wide angle Sony, Nikon, or Canon lens—all of which cost in the hundreds :)
I know there are excellent C-mount lenses, because I shot a great-looking movie on a Bolex with them.
No there isn't. Sorry. I've tried them all and their dynamic range sucks so bad....
Anyway, who thinks otherwise, I recommend you see the same non-ideally lit scene with for example a modern "analog" fpv camera like Foxeer Nano Toothless 2 (a starlight 0.1lux camera that maintains it's great dynamic range in full sun).
The only mipi camera that has a shred of a chance to compete is starvis IMX327LQR. On paper it should be pretty good. I'm planning to test one at some point.
Also, the cameras built into various Cctv Ip cameras one can buy from China are pretty good, but good luck getting them to work with anything other than the original equipment.
Tangent to your IP-camera comment: I replaced all my old SD, composite household security cameras with cheap-O TVI cameras, and I am impressed at how well this oddball HD format works over the same coax cables.
I have every official Pi camera, and they are all just terrible. I would never use them for anything artistic, when it's easy to get far-superior results from even a cheap regular camera or used SLR.
I'm just curious if there's a very-high-quality camera with a MIPI interface. Thinking it through... I only really care about video. Even if it's only HD resolution, something with excellent light sensitivity & low noise would be great.