This is an unpopular opinion here, but this article clearly suffers from reporting bias (successful projects don't get declassified) and selection bias (they found ~5 unethical/failed projects out of how many in CIA history)?
There are clearly classified programs that we know of that were wildly successful: the atomic and hydrogen bombs, U2 spy plane, reconnaissance satellites, and probably more that I can't think of now.
I would be interested in how this compares with other countries with intelligence programs of similar size. Could one find a handful of examples of unethical/failed projects from China, France, Russia, or the UK?