We may disagree, but I have no intention of shooting at you. Doing so would upset a whole bunch of moderators...
What I want to do is take the mystery out of long range (over 50 yards) shooting, because once one understands how it is done, and dumps the “it can’t be done,” attitude, it becomes quite easy. It obviously doesn’t require super-human ability, and it is particularly common in the western states where there is plenty of room to safely shoot at extended distances.
You can use a semi-automatic pistol, but a quality revolver with adjustable sights and at least a 6-inch barrel, chambered in .357 Magnum on the low end, and .45 Colt on the high, is a better choice. Avoid barrel lengths over 8-inches. A magnum cartridge, which offers a flatter trajectory may be advantageous, but isn’t necessary – and the additional recoil may work against you, especially if you are shooting a traditional Single Action with a “plow handle” grip. Ruger’s Bisley style is better in preventing vertical stringing.
Ordinary .38 Special service revolvers are good-to-go out to 150 yards or a bit further, provided they have an older style “pencil” barrel with a high front sight blade, which will allow holding up the blade in the rear sight notch to compensate for the bullet’s drop.
My point: An extra expensive custom handgun may be nice, but isn’t necessary.
Basic marksmanship skills are necessary, but they can be learned and perfected at distances as short as 50-feet (indoor ranges) or 25 yards (outdoors). Here, a pistol or revolver chambered in .22 LR is an ideal learning tool, as an understudy to your larger caliber guns.
In my view, long range handgun shooting is unlikely to come into play in a self-defense context, but it can happen, and obtaining the ability to use it if necessary is neither expensive nor difficult to learn.