I don't understand the mystique. These guys are superb physical specimens, not in terms of having bodybuilder physiques, but in terms of being equipped to endure the difficulties of hiking through rugged terrain and dealing with physical hazards. But they're men, and without adequate fire support they're just highly-trained light infantry. Using fire support from USAF, USN and USMC aircraft, the Northern Alliances routed the Taliban. There ain't no magic involved. Air support was the hammer and the the Northern Alliance was the anvil. These SEALs took a pounding because they were outnumbered, lacked air support, and had only what they could carry as weaponry.
Yes, this is what fighting an earlier version of the Taliban was like without air support
http://www.tribalanalysiscenter.com/PDF-External/Umbeyla.pdf
Irony of ironies, the op-tempo for specops troops the past decade has been so high, that this platoon was a group of SDV guys from Hawaii, trained for mini-sub ops locking out of dry-deck shelters clamped upon boomers and fast attack subs. About as far from the Hindu Kush as you can get, and still be a specops warrior.