You should fully own and control your home security cameras. Right now many homeowners are shipping their data to national datacenters.
Municipalities should fully own and control their public security cameras, on municipal datacenter resources.
Data sharing / federation should always be intentional and time-bound. It should be impossible for a small town cop to unilaterally access security records from a random city he has no jurisdiction in.