I think the main opposition is that some studies have shown that red light cameras are correlated with higher accident rates[1].

[1]http://blog.motorists.org/red-light-cameras-increase-acciden...