I hold the opinion or beleif I guess, inside 50 yards or maybe a little less, nothing is more effective or devastating than a shotgun. Centuries of street cred as a one shot stopper. In fear of my life suddenly and in position to take out the offender, I would want a 12 gauge pump, 00 buck, a Mossberg for the tang safety, and indoors, a bead sight. First choice. second for HD, a N-frame .45 ACP or 'loose' 1911 with 230gr. HST or Pow'rball in the 1911. Both shotgun and handgun options would be SOL on even a puny 200. IIA vest if the intruder was prepared that way. A headshot would be simple from a shotgun at room distance even under the stress of having to shoot a man dead to save myself and loved ones.
A Ghost ring setup (such as the Mossy 930 SPX, FN SLP, Wilson Standard Model, and Benelli M2 Tactical) and rifled slugs can work out to 100 yards (carbine range). Beyond that, reach for the .308 MBR or precision rifle.
You have an excellent collection I like the inclusion of the 6.5 and .50 beowulf. You seem to favor the urban carbine and must know it has pretty much consolidated/eliminated the use of submachine guns, shotguns, and full length "assault rifles" everywhere. Clint Smith's doing I think. But those weapons still have their own niches and things they can do better. In my example above, a shotgun can handle business within range most carbines get used. I think they're all good and useful.
Comfort with the weapon is paramount. This girl I was seeing last winter was 5' 9" and 110, and needed a gun for her apartment. She was a dancer and had large amounts of cash on her always, in a complex overflowing with Heroin, Oxy and glass dealers. I figured something with a stock would be the way to go for someone who never fired a gun. Thought about an auto carbine in a pistol cal or shorty lever in a revolver cal, or a M1 carbine. One day she spotted my new GSG-5 behind the seat which had fired reliably for me, and it became hers at that moment. HD with a .22? Damn right, the way she tap danced on those Rockstar and monster cans. First time and superb shooting Later took her to try out the 870 20 gauge 7 shot, and a few revolvers. Not interested. I don't tell this to reccomend .22lr as a suitable SD cartridge. But in this case, it was the GSG, or the butcher knife she was using before. I'm just glad she has a firearm and will use it if needed, though I miss that, second funnest toy I ever had (first was my 22/45). But an example that the best weapon is the one you know inside and out, spend time with, operation comes naturally. for me that would be a mini 14. But when it's do or die, I'll take the undisputed power of a shotgun (and a mossberg pump is also just as familiar)