They do have their uses, but the typical hero worship is undeserved, especially Hollywood crap in which they're represented as superhuman. Throw them behind enemy lines with two nails and a piece of rope and they'll build tanks, helicopters, airplanes and a makeshift base. After that they'll destroy ten enemy divisions, stop a nuclear warhead from launching, capture a dictator and be home for lunch. At least one of them will then quit the army and devote his life to his girlfriend who he dumped just prior to the mission. At least until the sequel in which he will again be recruited and he won't be able to refuse because of his sense of duty.
In the case of Osama mission you mentioned, think about what they really did - they crossed into another country illegally (creating a diplomatic incident) and performed an assassination (creating another diplomatic incident). The effect - Bin Laden is now dead, hurrah!!! Unfortunately, the terrorist organization is still alive and well and it falls again to the grunts on the ground to deal with it in the only way possible, by cutting the funding and taking away their manpower and support, either by direct combat or by winning hearts and minds of the population.
Bookmarks