For pistols, it depends upon the caliber. I normally shoot standing two handed and I practice at our steel swingers (4" & 6") at 50yds with all my pistols instead of paper targets.
I use my G21L 45acps to 100yds. I shoot my G20L 10mm out to 150yds and give the 200yd steel plate a go often. I just got my custom G24 finished and I've run it to 100yds so far.
For rifles, I shoot my ARs out to 500yds and I shoot my 357mag Rossi leverguns past 300yds using a tang sight. I even shoot my little Henry 22lr out to 175yds with the Williams receiver sight.
I figure that if I practice long distance shooting, I'll develop an 'aim small, miss small' style. So far, it works for me but then I have a range I can do that on and many are limited.