what unintended consequences?

The real unintended consequence is that cities ultimately don’t like to run them. They’re effective, and thus the revenue the city is expecting disappears. In they end they become costs rather than revenue sources.

The root problem is voters tolerating a government that sees law enforcement as a profit center.

that hasn't been true in any city i've lived in that had speed cameras (shockingly few actually). dc makes money on their cameras

$500 is just dinner for some people in SF.

Or maybe people will drive at 99 mph to get the best value.

is this different than the existing law? like they're not lowering the penalty

Speeding also carries point penalties. Get caught a few times and your license is suspended. You can’t just pay to speed indefinitely (unless you also buy something like a get out of jail free card from the police union).

A normal person sees that $500 fine as a incentive to not go that fast. But there's a certain kind of person for whom $500 is nothing compared to being able to tell the story of that time the city sold them a picture of them, complete with certificate that says they broke 100mph somewhere in the city limits, a trophy to frame and display openly in the garage next to said vehicle.

Really gotta wonder if the people that downvoted disagree that people would do such a thing, don't want to give people ideas and thus buried it, or are people who would do such a thing. Or some other thing.

Nothing special. Slight increases in minor accidents and near misses, some minority of which will involve pedestrians or road rage violence Basically the same downsides as anything else that changes the speed via rule or enforcement rather than changing the conditions of the road (e.g. "traffic calming").

i fail to see how adding cameras and an additional penalty will lead to any of those things

Because it only affects some drivers leading to higher variance in speed leading to more friction among traffic. Same reason everyone with a brain suggests traffic calming over changing the numbers on the signs.

This is transit 101 level stuff.