another thing to be mindful of is that Security/CCTV cameras are often CS Mount - not C Mount. the Registration distances are different despite the fact that the screw size of the mount is the same. C Mount register is 17.526mm versus CS Mount, which is 12.526mm. so using a C Mount adapter with a CS Mount lens will not allow you to focus properly (it won't focus to infinity, if I'm thinking about this correctly).
here is a list of all camera mounts and their registration distances - I found this to be helpful in knowing which lenses can be adapted to various other camera systems:
Alphabetical List of Camera Mounts
I have used D Mount lenses on my Q (many of them vignette - which is nice if you're going for that look), however, the adapter wasn't quite the right thickness to allow for proper focusing and I had to unscrew the lens a bit to achieve proper focus at closer distances. so there's definitely a registration problem with the adapter I bought, but I haven't had the motivation to figure that one out yet...