Hi.
So my advice is coming from a photography/ filming standpoint, so not sure if this works with what you need.
But the best cameras are built by those that build cameras and have done for a long time. Of course right? The reason being is that a lot of your image quality comes form the glass that is in front of the ccd/cmos or in the old days film. Terrible glass, terrible image. Glass also has its resolution capabilities and I believe they call it lines pairs per mm. Maybe you;ve heard of Carl zeiis, Leica or Hasselblad? No doubt you've heard of Canon and Nikon. All these guys know how to make glass. In regards to video cameras, then canon have a great combination of glass knowledge and image processing knowledge.
The next thing to consider is your ccd/cmos. The world got all caught up in the megapixel race, and making cameras really small. Which meant ccd/cmos's got really small, and also they crammed a lot of pixels on them. That is a false economy in regards to your image quality. What we need, and again Canon has turn 180 on the industry for the better, at least for video where our TV's and output devices are only 1080, they have built bigger sensors with less but larger pixels, in fact just as many as we need 2 megapixels, 1920 x 1080. This means that an individual pixel is more sensitive to light, which means less noise, which means sharper images even as the light drops. Flash back to film. Film speed was based on the size of the silver particles in the film. 800 film had larger silver particles which react quicker and sooner to less light than did say 100 speed film which has small grains of silver in them.
So, if you have a budget and OpenCV works with them in terms of live uploads etc, then look at Canons new HFG range. Starting around 1k. Not sure if some of the lower models have the same sensor, I think they might? But here you get great glass, amazing and big cmos sensors, and also HDMI out. Guess they will be heavier than webcams and things like that so they may not suit for many robotic projects.
Otherwise certain things to look for.
Glass lenses not plastic.
If the lens is designed by a well known lens manufacturer even better.
The bigger the glass the more light is let in, which means better images
Just enough pixels for the job. On bigger sized sensors. with bigger pixels (sometimes called pixel pitch measured in um).
Guess its all food for thought, not sure if its helpful at all.
I would be interested as well.