If just a few localities had regulations like this covering government and private cameras, and if they were reasonably well designed regulations, I'll bet it would be a huge privacy benefit that would give people more peace of mind and improve communities.
There will always be some exceptions for whatever Black Ops are going down in the desert, or whatever, but a lot of these needlessly anxiety-making camera-human-sensor-loop systems could probably be brought to an end quickly.