Me I have been shooting for about 20 years now and that's all forms of firearm.
That being says 25m is an OK range for someone who shoots maybe once a year. Ie Police or Military shooters.
I have shot magnum handguns out to 100m and I know people who compete with handguns out to 200~250m. I also know people who hunt with handguns who have taken game at around 100m.
the man who designed the .44 magnum once dropped a wounded deer out at 600 yards.
Article
All that being said Unless your character is clearing a very small space a handgun is an emergency defensive weapon. It's something you carry so that if your Automatic weapon goes down you have a better backup weapon than your fists and feet.