Following up on this (had some family things going on), I guess what I'm really looking for are cameras that have similar performance to the Hik ColorVu cameras I already have, but perhaps in a smaller form factor (these are quite large) and higher resolution. Here's an example image from one of those. They're a little older, the model number is DS-2CD2T27G1-L 2MP.
(I masked out identifying information in the top right and bottom left corners, otherwise the image is untouched).
It's hard to tell from the screenshot, but there's VERY little ambient light here. This is a fairgrounds in a rural area, and it was close to pitch black outside when I grabbed this screenshot. I understand that zero ambient light = zero picture
View attachment 221426