Actually I aim for a balanced 
video. Not too much noise nor blur..I’ll accept more noise than blur if it makes enough difference in being able to positively ID the target.
But I know I'm at the limits of either the camera or available light when I can't find an acceptable balance. The answer is almost always, add light.
I find much of the tweaking of a static snapshot without a moving target to be mental masturbation. Sure on first initial dial in I strive to get a clean image, but without a (human, vehicle, dog, gator, giraffe ) moving target in the various lighting conditions, one doesn't really know.
I tend to spend wayyyy more time on nighttime scenes than day. Frankly any decent sub $100 camera can get reasonably good pics during the day, I want to be able to see that there are separate blades of grass at 25ft, but I don't need to be able to count them. But at night, and in the hardest close-in scenes where facial ID is critical, there are usually multiple light conditions even within 0-15ft of the camera and I find it much more difficult to get a great snapshot of the bad guy testing my door locks.
On the other hand some folks live in very beautiful remote settings like some of our our Alaska members for instance, where few if any bad guys come calling. There, still shots of the breathtaking scenery or aurora's are essential and many have cameras dedicated to doing just that. I envy them.
This car snap has a small amount of blur, its not perfect. But its more acceptable to adding noise from a faster shutter. I don't see any gain to be had that will make a difference to LE in ID of the vehicle.
View attachment 231397