Those cameras end up costing the city more than the accidents they don't prevent. What happens is, there are less red light crossing collisions, and more rear-end collisions. Eventually, you have less red light runners to ticket, but that turns the red light camera into an expensive cost - at least $4000/mo for each camera. You have to make more than that at each stop light to justify the camera.

The real solution is to make sure the yellow light is set with proper timing for that road. A yellow too short for the intersection increases red light running and potential for rear end collisions. But if you did that, then you won't make anything on red light tickets, because no one would run the red light.

So the real problem is trying to budget the city based on criminal activity - you are effectively requiring a certain minimum level of crime to balance the books.