"Has the CIA advanced American interests" is the wrong question. The CIA does not work for "The United States" proper, it works for a tiny section of it that comprises the ruling elites. Those people certainly enjoyed significant material benefits from CIA actions in Guatemala, Panama, El Salvador, etc.
> 4 decades of James Bond, Tom Clancy, Homeland, Zero Dark Thirty
Not really. See [1]. A competent clandestine service lets one achieve foreign policy goals without going to war.
But more to the point, pretending everything one doesn't like is an elite conspiracy is self defeating. If you want to gut the CIA, convince voters to hate it.
>Not superbly. But more than the IRS, DoJ or Department of Education.
Three letter agency that mostly harasses people outside US borders polls higher among US voters than three letter agencies that do most of their harassing within US borders. Water is wet.