The fully functional CCTV cameras generally will not point much above the horizon, fixed cameras are looking at one thing in particular and usually that is not sky. I have fitted cameras that can identify a person at a mile away, fitted with a IR laser for illumination at night but that is not your typical CCTV camera. I had occasion to do a test with a prototype camera and lens against an existing camera fitted with an image intensifier, the camera I was using would go down to almost as low light as the intensified camera but still have a colour picture, when I switched it over to monochrome and commanded the IR cut filter to retract then the camera went as low as the intensified camera. The test was to detect a group infiltrating a secure site which I could do, I could spot them well before they reached the fence line and the intensified camera couldn't. What you see on the news and caught in camera type tv shows are not representative of what a properly setup camera system can do. With that prototype camera I could see the nebula in Orion's sword. Now that camera was being tested 17 years ago and I retired from the CCTV industry in 2005.
Video I took using that CCTV camera: