The British actually got their war goals despite losing most of the time. That's why the Pashtun are divided by a line the British made. The Soviets managed to create a state that outlasted them, stopping the equivalent mujahideen attack in its tracks[0]. That state only fell when the USSR itself fell. The US failure is exceptional in the amount of resources cost, the quickness of collapse, and in failure to reach objectives.

[0] https://en.wikipedia.org/wiki/Afghan_Civil_War_(1989%E2%80%9...