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.