I don't know that much about various inteligence agencies to compare them, but CIA has been doing a good job, I think ( what actually their job is,
now thats a topic for another discussion

)
Outside US, I'd say Mossad and british inteligence are quite good.
To those laughing about military inteligence:
One of the golden rules of war is never EVER underestimate your enemy.