The original red-light camera trial was in Scottsdale Arizona. The city farmed out the study to a university research group, and the cameras were installed at a random selection of the worst red-light-accident  intersections. The trial was publicized and ran for several years. The timing of the lights was not changed.
The conclusion of the trial was that the cameras reduced both accidents and injuries. Scottsdale then ran the cameras for years with general public approval, in part because the city has some pretty rational traffic ordinances (like raising the speed limit if most people are going faster anyway) and an open set of books on the program.
The cities that treat red-light violations as a revenue source and especially those that cut yellow times to increase red violations have only themselves to blame for poisoning public opinion. If anything, cameras should be paired with longer yellow times.
Scottsdale is strange that way. They also did studies that showed that traffic flows better and reduces accidents by having left turn after green rather than before. Those results have been mostly ignored by other cities.
PS: I've seen some of the footage from the cameras, by the way -- one truly amazing one of a guy who totally spaced and drove right through an intersection well after cross-traffic was flowing but amazingly managed to miss all of it. Hard to believe.
 Skip the joke. It's ancient.