Two choices given the requirements...
1) an old smith&wesson model 10 police service revolver
2) and old 9mm glock police service pistol
Cops trade in their guns from time to time and get something newer. Look for one of these in a gunshop.
I bought one of those (A Model 10-10) from Bud's Gun Shop online. It was an old Australian Police gun, and has a good amount of holster wear, but locks up solid and has a wonderful trigger.
It sits on my nightstand as my home defense gun. I do have a shotgun (Mossberg 590a1), but the good-old Model 10 is my favorite for the home.
The Model 10 is also the only one of my guns that my wife is comfortable shooting.