Personally--and this is just me--I always found the M9 to be especially useless. Therefore I find your logic faulty. I award you no points, and my God have mercy on your soul. Then again, that's just my opinion.
I would highly encourage you to go to your local gun store and just look around for a bit, handling different firearms and getting a feel for them. Ask questions. If the staff gets pissy and/or tries to peg your BS meter, I would go elsewhere. Better yet, find someone local who you trust and knows a bit about guns, and take them with you. Have them explain as much as possible about what firearm you're handling, along with pros/cons. Still better, take said firearm savvy individual to the range and offer to pay for range fees if they'll let you shoot their guns.
Get a feel for how the firearms fit you, balance, how they shoot, etc. Can you reach the controls safely and efficiently? Do you feel comfortable with the particular safety mechanism(s) on the firearm? Are the sights, size, caliber, material, capacity, etc what you want for your chosen application*?
You implicitly stated that you were looking for a pistol, so that's what I'm kind of running with. But the same applies to long guns.
*--The task drives the nature of the tool. For example, I would not buy a .500 magnum revolver with a 7 in barrel for concealment purposes.
There used to be a place a mile or two past the tunnel on the airport side of 279N, right off the highway. I haven't been there in years--and even then only twice while home on leave--but it was/is an indoor range that rents pistols and had a decent selection.