[dr-ando]

Any camera modules you might recommend for such tasks, ideally compatible with the nano?

[dejv]

I can't remember the name of vendor, but they were from some niche manufacturer of professional machine vision cameras from Germany. Each of those cost few 1000s euros.

Almost anything for industrial use cost you a leg and then some. If you want to experiment with CV at home I would take a look at that high quality camera module from RPi.

[cmxch]

Is the HQ camera module any better than the Veye Starvis (imx297/307/327) module?

Aside from being a third party module, they do quite well with low light situations -compared to conventional Raspberry Pi camera modules.