Usually the DA-only thing is for DEFENSE pistols.
Nobody in their right mind would try to shoot SA in a gun battle at short range.
Accurate distance shooting DA is entirely possible, and it's simply a matter of practice.
Back in the late 1940's, early 1950's there was a man who went around the target shooting circuit making bets on his shooting skills.
The bet was, you would shoot your 6" S&W or Colt target revolver single action at 50 yards.
He would shoot his Colt 2" Detective Special DOUBLE ACTION at 50 yards, and his bet was he could out score you.
This guy cleaned up, and people could never understand how a 2" revolver could out shoot a 6" much less in DA only.
His "secret" was, first, he had a custom tuned Detective Special with smooth DA trigger, and a revolver that was in 100% proper adjustment.
EVERYTHING was set to optimum specs.
Next, he was a great shot who'd practiced with his gun until he'd mastered it.
He knew that if you pull a DA trigger until it was JUST ready to drop the hammer, then stopped the pull, the remaining pull was really little different than in single action.
Learning how to shoot for accuracy DA is one of the "games" revolvers shooters can play, and it can be quite fun.
One year, I bought a Colt Trooper Mark III in .22LR with a 6" barrel.
The Mark III is a massive revolver to start with, and the tiny .22 holes in the barrel and cylinder made for a heavy gun.
The weight and a tuned trigger action made DA shooting easy, and I spent every summer and fall weekend with a 500 round brick of ammo practicing DA shooting exclusively.
By early winter I was shooting pecans off trees, thrown rocks out of the air, and cigarettes off fences double action.
In early winter I switched to a Marlin 39-A rifle, and shooting it was almost TOO easy.
The pistol shooting skills do translate over to rifles, and the trigger control and sight concentration make it much easier to shoot rifle.
Since then, I believed the way to become a good shot with any gun is to buy a good .22 pistol, buy plenty of ammo and just SHOOT as often as possible.
As for double action shooting at distance, again, it's just one of the games you can play with a revolver, and I thoroughly believe it can increase your shooting skills even in single action.