One could add:
The Barking Dog
Barks at everything all the time, people learn to ignore it. Then, when there's real danger, no one cares, providing literally no value and becoming only an annoyance.
It's kind of like a dual for the security guard one.