The king of low light is the 1/1.2" 4K cameras, the downside is they dont have and cant see IR light. So you need to have good external light.
The bullet is better than the turret due to small FOV focus issues
$50-$100 cameras are not going to perform well at night. They use cheaper sensors and shove too many MP on the sensors designed for much less MP, thus compounding the problem even more.