There's a lot of stuff at play here.

First, despite the Millennium challenge being "debunked", it still played out in the same direction.

Second, and this is a big one, after the Church committee when the CIA was put under congressional oversight, a big majority of the clandestine work was put under Special Ops type groups, ie the Army Rangers, Navy Seals, etc.

When we were in Afghanistan, we would do the "target the leader" game, but it was far more dark in reality. Since we were going against a distributed insurgent force, we would send the special ops guys to targets intelligence deemed important. There'd be an op tempo of 2-3 a week. Years passed, and we didn't make any headway, so the op tempo was increased.

A target would be chosen, and the operators sent out. They'd kill the target, and look for any papers/documentation with other names. If you were this guy's dentist, you could be caught up in this. Since a majority of the operators didn't speak the language, they had no context to the names. It was more like the metadata network of connections exposed by Snowden.

Since we needed more operations(2-3 a night instead of a week), we'd go after less and less important targets, tangentially related to another target. We effectively turned the special ops groups into clandestine death squads with nearly zero accountability.

In addition, we were supporting warlords in the area that were pro-poppy cultivation and anti-Taliban. We'd protect the poppy plants that would go on to supply a large majority of the world's Heroin supply.

Where is this going? Well the cynic in me says it's simply a scam. We spend more on fancy military hardware that allows us to kill more effectively while barely pushing the needle on our goals. The mass amount of death we drop on populations creates new generations of "terrorist/freedom fighters" who rightfully have a grudge against the US war machine.

The money spent doesn't move the needle materially, but it provides propaganda in the form of "look at our death machines, we have the most in the world", which is a double edged sword of "hoorah" at home and "don't fuck with the crazy guy holding the gun" outside of home. The expensive weapons taxpayers buy from defense contractors are too expensive and complicated to build in bulk, so we run out quickly the second we have an enemy that can shoot back with more than an AK.

We're still trying to fight the war of 2-3 wars ago. We also learned from Vietnam that by no means should the general public easily learn the reality of the war. That worked until recently when the victim of a proxy war was able to upload daily videos onto tiktok and break the decades long good will between the US and an unnamed vassal.

Anyway, tl;dr, the ole military industrial complex is still at it, lobbying our government to spend money we don't have on wars we cannot afford as a public works program that only excels in death, rather than public works in healthcare, infrastructure, science, etc.