The M110 isn't a SOF gun. It's a P2 big Army program of record. SOF units are MTOE'd their service components standard weapons, vehicles and equipment and use their SOCOM P2 funds for other equipment solutions. SOF(to use a general term, but one organization in particular) helped R Knight develop the SR25 through iterations for 10 - 20yrs before the M110 came around. I have been issued, used in combat for 19yrs in GWOT, the SR25, the M110, the M24, the SPR, the MK13, and the M2010. In various MODs and iterations. All those guns are over-hyped in my opinion. I was always surprised by how poorly the SR25's I've had shot and just assumed it was me. But I also now realize my naive expectations were unrealistic. I just took the hype as truth. They shot about 1-1.5 moa and it was"good enough". M110 was a complete debacle and the worse version of the SR25 I've seen. It loosens up after a thousand or so rounds to a level of inaccuracy that is completely unacceptable. Like 3 to 4 moa. It doesn't deal with heat well at all and had issues with triggers letting go. They would begin to double tap when they aged. The fit on the massive can required the shooter to "seat" it by shooting 20 to 30rds to "seal" it with carbon. And we constantly break bolts because M118LR was designed for bolt guns and on top of that it has gotten on the average of 50fps faster over the last 10 years. It's bad enough that we all realized we needed a better sniper rifle and procurement for a new gun resumed before the M110 had been around for a decade. The HK CSASS was selected and the Army just decided not to fund it in the end and so it is unfielded. But TACOM did end the maintenance program for the M110 bc it is no longer the program of record. So we have a broke-dick sniper rifle that units have to pay for maintenance, unforecasted, out of annual O&M money (unit budgets). Meanwhile the last round of COVID stimulus has bumped the national debt to a level at which the interest exceeds the DOD Defense budget. For the first time in history. So this situation isn't getting any better. The military is taking a huge bath to try to come up with as much money as possible to mitigate the national debt.
Everyone of those guns I mentioned are a crude and "industrial" grade compared to the civilian equivalent. They get the job done but they are by no means perfect. They break on guys in combat, have been victim of the technology available of the time, that was affordable at a mass procurement level, and get skull-dragged over mud walls. When I see civilians shelling out $5K for an M24 I throw up in my mouth. To each their own I guess.
I have always been perplexed by the fascination on invincible reliability by civilians. To me it's a myth. No gun will meet this and we account for this through the employment of interlocking sectors of fire, mutually supporting teams, preparatory fires, primary and secondary weapons, and in general over-matching your opponent so it doesn't come down to a "fair", 1:1 fight. Combat Marksmanship and Advanced Urban Combat are riddled with failure drills, weapon transitions, and the use of cover for just this reason. TT&Ps make use of contingencies, backups, redundancies, and PACE plans. If you read gun forums or watch youtube videos you see people constantly talk about "trusting their lives" to such and such gun. Just like folks at matches talk about the most important thing is safety. And then you know in the back of your head that thousands of guys spent two decades with poorer performing guns, getting flagged by jundi's every night, chasing bangs and charges, taking a huge buffet of vaccines... I think much of what you see is overblown, based on the perception of reality. I would agree, a person can get a lot done with 1-1.5moa and a certain amount of reliability is required. The SR25's were reliable. They were better guns than the M110's, but no way I'd spend the money on one. But I'm not sentimental and don't really get into "ownership".