I used to think of a 12ga as being as good as it gets,energy,hit likelihood,wounding ability,etc. I don't question for a second that a scattergun eliminates any fight. In home we're talking 30' ,less in most of the apt I've ever been in,as a maximum range. Hand guns are far more maneuverable in CQ. They're harder to take away,less leverage and you've got 2 hands on the power switch. The Glaser ammo and the powdered metal"green"ammo are good choices. They reduce the risk to neighbors other occupants and the fridge.
The best of both worlds? How about a 460 S&W or a Judge in a 4" variety? 410s come in every flavor these days from 9s to 9 flat lead washer reminiscent of the" load of dimes" to 3-4 OOB. From those w/bird shot there's a 2 foot pattern at 20 feet ,you'll have an attacker that can't see or breath. Use the" dimes" or buck and ball or strait buck and you get terminal injuries. The 410 will work dimensionally in a 460 but I've not seen it suggested.