It's hard to say, because you rarely hear about the successes they have, just the failures. But the US intelligence community played a key role in the fall of the USSR, denuclearization of Iran, and I guess arguably the success of south korea given the US's required action to stop the invasion from the North. Obviously all those things could be bad depending on your political philosophy, but I'm going to go out on a limb and say most Americans approve.
And that's to say nothing of the intelligence community's key role in Ukraine and specifically the recent counterattacks.
But even as the Biden administration has declared it will not deploy American troops to Ukraine, some C.I.A. personnel have continued to operate in the country secretly, mostly in the capital, Kyiv, directing much of the vast amounts of intelligence the United States is sharing with Ukrainian forces, according to current and former officials.