I don't have much meaningful info to contribute to this, but it is interesting to observe how the rollout of the red light cams happens in different places, and how it eventually turns out.

IIRC there was a point in time roughly around ~2017 when it happened in Redmond WA (i.e., in the town that the Microsoft HQ is in). I might be off by a year or two, but it doesn't really change the overall point.

TLDR: in under 2 years, that whole red light cam initiative got canceled and reverted, because the local stats showed that it just made things more dangerous on the roads (by significantly increasing the rate of rear-ending accidents at traffic lights).