I'm not from the US, but it would seem to me that public cameras should only be accessible for legitimate purposes.
Police should need to request footage, but similarly, you shouldn't be able to just request any footage willy nilly, because of stalking.
Seems that it should be tightly regulated and require multiple people to gain access, and be documented who was given access.
Overall your comment seems like a great suggestion to me. If footage "goes missing", they had better have way more evidence to back up their charges.