I am chosing, perhaps naively, that the Chicago red light cameras are an exception and not common because that whole process was criminal: https://www.justice.gov/usao-ndil/pr/former-redflex-ceo-sent...

That I couldn’t say. It at least provides a model. Most city or county governments have some influence over their traffic engineering or streets staff as far as high level planning concerns.