My impression is that Angleton was on the whole a destructive force.
I haven't tried to get a full measure of him and his actions (for one thing, I suspect that's going to be impossible until everything from the relevant periods are declassified), but my major point is that the counterintelligence function is essential and we pretty much just don't do it.