To the extent possible I have. Although I am not in any service.
An operator is a tool; a very sharp, refined, razor edge tool. But its effectiveness will always be dependant upon how the operation as a whole is planned and executed.
American SOF (supposedly the best) and with whole bunch of allies couldn't do jack in Afghanistan. Sure they must've done great shock and awe raids and some war crimes(a la Australians) to stoke fear in enemy ranks.
But how effective was that at the large scale? Afghanis made Americans and NATO chase their own tail. The guy who is one day ANA general, whom they are briefing about how things are gonna go down. Next day he has defected to another faction. Or is AWOL. Or some politician they were grooming now suddenly is Taliban cuz some stupid soldier insulted his religion/culture.
Socio-Politics is where America lost it in Afghanistan
Compare that with same American SOF/SOCOM in Iraq where similar loosely controlled SOF units with more autonomy/loose command structure yielded much better results.
To go along with that US civ-mil leadership played Iraqi socio-politics against Iraqis very well. It was a country which had systematically been starved through sanctions much like Yemen and then picked from the tree like ripe fruit.
So SOF units are just a tool. Dependant upon how good the greater game is planned.