It just depends on usage
But, for me, nearly all my handguns have adjustable sights. I rate them an absolute necessity for a good .22LR.
I like a gun to hit where I aim. And I like to be able to do it with whatever ammo I am using. It may just be a personal thing, but it's what I want.
Service autos with windage adjustable rear sights are not too bad, but you are more restricted than with good adjustable sights.
For a pocket gun, where you need to hit center of mass at a few feet distance, fixed sights are no disadvantage, as long as the front sight can be seen. Otherwise, point shoot.
As to adjustble sights being more fragile, yes, but...in nearly 40 years of using guns, I have never had a situation where I damaged a rear sight. And as a small arms repairman in the army, I saw several situations where the fixed rear sight was damaged. Against some things, nothing survives unscathed.
As to being more snag prone, if you keep your pistol in your pocket, maybe. I always found the hammer to be a bigger problem snagging than anything else.
One thing that really gripes me is a pistol that is obviously intended for hunting/target use that doesn't have adjustable sights standard. I can understand a duty pistol not having adj. sights, but something like a Desert Eagle? Standard sight, drift adjustable for windage only. The adj. sight is an expensive "option".
So, if you only shoot one load (the one that hits point of aim), no matter if it is the best load to use, then fixed sights are just fine. Otherwise make mine ADJUSTABLE.
Another thing to consider is the fact they no two people look through the sights exactly the same way. In some cases it can be a large difference. My late father was deadly with his handguns. Only shot one load (factory ammo), in each. But he looked through his sights differently than I do. Shooting his guns (and his ammo), he would use a center hold, and nail the center of the bull. I had to use a six-o'clock hold to do the same thing.
If the guy at the factory looks through the sights the same way my Dad did, then no fixed sight gun he zeros is going to shoot right for me. With adjustable sights, a few clicks with a screwdriver makes everything A-OK.
I handload, and I don't always get the same brand of .22. I need the ability to adjust my sights to match the ammo I am using. For a concealment piece, no, adjustable (target) type sights are not a real good idea. But for everything else, including a service pistol, give me the option.