Revolvers shoot left for me...Rugers (over a dozen through the years), about 2-3" at 25 yds. These I've corrected by CAREFULLY filing the rear sight notch. 2" at 25 yds is about the limit for correction with this method. All shot high as well. I want my guns to impact at the tip of the front sight at 25 yds with my loads. I fine tune the most accurate, usable load then correct the sights to achieve that impact point.
Autos have generally been close...Sigs, 1911's [Ruger, Colt, Sig, Remington-Rand], and a lone Bersa & a cpl of S&W's. By close, I mean 2" or less at 15 yds from a Weaver Stance. All were easily, more or less, adjustable by drifting the rear sight. All were ok with elevation, generally high by a cpl inches, except the Sigs which the company insists on installing with a "Combat" sight picture [Read: cover the target with the front sight dot cause the bullet's going to impact at the center of the dot]. I've learned to accept this...don't like it...but it works and there's no alternative except replacing the front sight which is all but welded in its dovetail on the half dozen Sigs I've worked on.
Adjustable sights belong on any handgun...and no...they are not any more fragile than fixed sights. You're just as likely to knock the front sight blade off a fixed sighted gun as you are breaking the rear and/or front sights on an adjustable sighted one. The answer is obviously, "Don't drop your guns!" Either type is just as likely to break.
YMMv Rod