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.
And that's to say nothing of the intelligence community's key role in Ukraine and specifically the recent counterattacks.