> In the end the CCTV doesn't actually prevent anything from happening ...

The question of whether it prevents things from happening is a question of statistics.

I suspect the data doesn't support your claim, and that certain categories of crime have indeed been deterred. But neither of us can know without that statistical analysis.