I'm gonna get downvoted for this.
But I'd like cameras in my neighborhood. Sure, there's a security risk but there's also a risk of not catching criminals due to lack of evidence. Tons of crimes aren't prosecuted due to the lack of evidence.
A security risk doesn't impact average people, and it can be handled more easily.