Interestingly, there has been some research on this. Among suburban people in the UK, satisfaction ratings with the cops are significantly lower after an encounter with them than before. (The only public service of which this is true.) This suggests to me that people love the fantasy of narcing on their neighbours, but then are disappointed in the result.