I'll add my $0.0000000000000000000001 to this discussions more so, for food for thought. Any extra lighting on the property is a good thing. It enhances the curb appeal, provides health & safety as it relates to lighting a path way, while increasing the ambient back ground.
As others noted with anything it comes down to the equipment, installation, and environment.
Like external IR lights if spec'd correctly, installed correctly, this will increase the area coverage. While reducing incidents of bugs, IR glare, and extend range. Given the advancements of solar lighting that span from 2700 ~ 6500 K and come in all types of sizes and features.
It's never been easier, cheaper, or a better time to invest in the same . . .
You install any of the garden lights that can shine on the side of the building? You've not only increased the curb appeal of your home but you have increased the target area from zero to more. You install a perimeter flood light that is properly angled with enough light spread again this will increase the lux from zero to more. Like others if you use something that turns on (motion activated) the hardware in place must be capable of reacting to the same.
Otherwise you will literally miss anything that transpired . . .
Regardless of all the above its important to stress that some cameras should always be locked in day vs night mode. This avoids the camera having to switch the IR filter and thus causing a missed shot. As has been stated countless times on this board and others everything must be tested, validated, and follow up.
Because the environment will change with the change in seasons . . .
Thus, something that was fine in the summer isn't going to be rocking in the dead of winter. Conversely, you may very well find due to the fact there is snow on the ground this will increase the cameras ability to see better longer due to the light reflection!
Given, most people are hard pressed to have five cameras never mind 20~64 on their property. I can understand why people leave the equipment on auto vs locking the same to day vs night. In the ideal world all three would be used to address the intended goal of that money shot.
Not everyone has won the lottery or made of money so I understand when people say I only have this but want that! At the end of the day compromises happen but this limits what you're able to get. So it really comes down to investing more to allow a person to attain that goal.