Any camera modules you might recommend for such tasks, ideally compatible with the nano?
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.
Aside from being a third party module, they do quite well with low light situations -compared to conventional Raspberry Pi camera modules.