Supposedly the Patriot Missile was protecting Israel during the first Gulf War, but there are as far as I know zero confirmed hits (IIRC the Pentagon generously thinks that a few scuds were deflected, but Israel thinks otherwise).
The point is that just because a program is thought of as 'famously effective' doesn't mean it actually is.
