I always found this issue to be confusing. There are literally hundreds of cameras tracking me every day: in the parking lot, in front of the ATM, when I buy my groceries… I have no ability to know when I’m being recorded or what happens to those recordings. Yet some people are upset if they get photographed by a human photographer in a public space. Is the only difference that the photo was taken with intent?
CCTV footage doesn't go viral, and my social circle won't see it. I find it hard to understand that people in this thread see no problem there. You can still believe that photographers should have every right to take photos (and legally they do, so there's nothing to discuss about the status quo), but you need to address this point, even if only by summarily dismissing it.
It absolutely can and has. Such as if the CCTV captured footage of a crime or a suspect of a crime.
Additionally, if the CCTV is government controlled, it is subject to freedom of information laws (FOIA), which means anyone can get a copy of the footage for any reason and use it for any purpose. It is in effect public domain.