So what is the solution for good day AND night time images? Have two cameras (color for day and B&W for night)? Spend $$ for a better all around camera? Get good lighting that comes on with motion detection?
Do the color cameras that switch to true B&W at light really work?
True Day/Night or "24 hour" cameras also as you said cameras with dual imagers also wok well. I have a variety of both. Yup they cost more starting around ~$300 ($250 for CTers) and going up.
Good lighting is always nice.
Yes but there is also optics that make a big difference. However most cameras just kill color saturation to make a B&W picture and kick up the gain. Thats exactly what that Xavee POS was doing in that video clip.