We had loads of red light cameras where I am, and while there are still some around the vast majority were removed because they caused drivers who otherwise would have safely blown a yellow to jam on the brakes, much to the chagrin of the person behind them who suddenly had less braking distance.
And yeah, people should leave more room, but they don't. So you get enforcement camera-induced accidents, thus defeating the purpose.