It really depends on the municipality: I would vote for this in a heartbeat, and so would a lot of other people in my area. There would also probably be some opposition, but I don't think it would be particularly lopsided against these kinds of cameras.
I think it is one of those things people might broadly support, until they themselves get a speeding ticket and start throwing a fuss. Traffic laws, in particular, are things people want strongly enforced on everyone else.