If we’re talking handguns in the home, whatever the caliber, a revolver is the best because it is simple to load and if it misfires, you just pull the trigger again. I would personally recommend a .38 or larger.
Use Glazer or Mag Safe ammo. If you miss, the bullet won’t go through the wall and kill someone innocent, but if it hits the bad guy, he’s in for one very bad day.
Some use the Corbon Pow'Rball with frangible bullets.