The idea of policing people using cameras seems more than a little Orwellian to me. Why not just mount those cameras to things that can move? What if the moving-police-thing-with-cameras also carries around handcuffs and is connected to an AI so it can make decisions about whether it thinks you've committed a crime and then arrest you? Is this really the way we want to use technology to build a better future?
Orwellian sounds a bit over the top. It's a camera that takes photos of cars that are speeding. In 20 years of driving I've never been bothered by them. As long as the tolerance is fair (not get everyone going 1km/h over) then what's the problem. No one is forcing you to speed
Where I live, the tolerance is 10% (although they don't want to admit it). So you have to be doing 110km/h in a 100km/h zone or 66km/h in a 60 zone. Car speedometers usually always read faster. Sometimes as much as 10%. To be done with a speed camera, you have to know you're doing the wrong thing. And for fixed location speed cameras? Just slow down when you approach them if you like being a speed demon on the roads
Like I said, if the cameras sign posted are put in black spot locations that remind people to slow down in those areas, that's a good thing. Speed later where it's not as big of a deal 
You're putting a lot of trust in the powers that be not using those cameras for any other reason at all, while also giving control over to computers to decide if you've commited a crime or not. I don't think the comparison is over the top at all. Once we start handing responsibility over to computers to police us, the people selling those things look for ways to expand their offerings. That's the way of the business world - land & expand.
Why do we need computers to be police officers?
I'd trust a computer over a person.
Computers do what they're programmed to do without bias.
People.... Don't.
A cop could pull me over for speeding regardless if I was speeding or not. If I contest, thats another offence, possibly including being pulled from the car and arrested at gunpoint.
Meanwhile, a speed camera takes a picture and sends you a fine in the mail, which you can contest in traffic court. And the machine's logs will tell the story. Its also much harder for most people to tamper with said logs to catch someone unjustly and if the software is written in a way to be unfair... Well, again, its evidence someone can follow up on as such things will show up in logs or decompiles.
The big issue you need to worry about are stoplight cams, as JJA said and cams in spots like at the bottom of hills where you naturally do over the speed limit since you haven't had time to slow down.
And if you are honestly afraid of such misuse, then you need to elect a new police chief for your area because cameras or not, they will misuse anything they have for whatever their goal is.