At the core of the question is - lighting.
Anyone wanting to see in true
Colour at night will purchase the largest optical lens possible in the given sensor size.
This is why accent, local, and perimeter lighting is critical to obtain that money shot while reducing motion blur / ghosting. This again is focused on a single purpose which is to identify a person or object.
When the goal is NOT focused on identifying vs presence detection other technology are much better from thermal and IR.
The biggest problem I see as it relates to true security is the lack of understanding of layering and information.
If you know a thing - you can react to a thing!
Meaning you should have system(s) in place to provide you advanced warning think: Drive way / Gate / Fence alarm
Once that advanced warning has been given the other layered systems that are integrated can come into play think: Spotter / PTZ cameras
With the advancement of being able to link several cameras (trip wire) from spotter, PTZ track, and fixed local ID cameras. You literally have a system that companies and governments use but on a much smaller and simpler level.
Lighting is basic, but often overlooked as to the importance of such!
Keep in mind none of this addresses those who want to run stealth. As noted early on
If you know a thing - you can react to a thing. As such hidden security elements of various sensors and cameras must always be present and deployed because someone is going to take out the systems they can see or access!
Those who are so called preppers or served in the military or work in IT know the following phrases: 1 is none - 2 is one, power of 3, 2N+1, backup, fail over, redundancy.
At the end of the day the 4 rings of security must be understood and followed.
Rock On . . .