While the op stated 9mm, 45, etc (assuming straight wall), IF one wants to go beyond the more typical ranges of bullets styles used in revolvers and semiauto pistols, the single shot handguns can give extended range with the same straight wall cases, i.e. 30 carbine, 32/327 mag, 357, 41, 44, 45LC etc.
When using the Contender or others, the case can be loaded with spire/spitzer or long RN type bullets. I've loaded a lot of 30 cal 110 spires in 30 carbine, .358 150-180gr spires and 200gr seated long in the 357 mag and 357 Max for better BC and down range energy. In my 357 Herrett (not straight wall I know), I had good success with 200's seated out. The Hornady Flex Tip, FTX, really adds distance to bigger bores like 44 and 45.
Again, if your plans are to stay straight wall standard pistol/revolver cartridges, these are some options. If you want to really go longer range with pistols, the bottle necks or straight wall rifle cases (375 W) is where is it at. I love my 7mm's, 30 AI's and larger case 35's in the single shots.