The HQ has a C-mount so you can put any C-mount lens on it. And there are plenty of options in that space.
In my case, I simply can't stand the raspberry pi's camera connector so I buy my own "industrial machine vision" cameras with C-mount. In my case I found the Mindvision line to be the best, I connect with either USB3 or GigE (both of which are much nicer cables than the Pi camera connector) and use the Mindvision SDK (it's not a uvc device, instead you write some python that interacts with the camera, giving you deep level of control).
In my case, I simply can't stand the raspberry pi's camera connector so I buy my own "industrial machine vision" cameras with C-mount. In my case I found the Mindvision line to be the best, I connect with either USB3 or GigE (both of which are much nicer cables than the Pi camera connector) and use the Mindvision SDK (it's not a uvc device, instead you write some python that interacts with the camera, giving you deep level of control).