If you want a gun that ticks all the boxes, get a 12 gauge shotgun. It's a cheap, widely available platform that has cheap and widely available ammo, it just fucking works, it's easy to care for, easy to use, pretty standard maintenance, and will kill what you need it to. They're lethal much further out than video games imply, because otherwise they'd completely wreck the balance of the game.

Yeah, with a 12 gauge shell of 00 buckshot, every pull of the trigger is almost like mag dumping a 9mm handgun in that direction. Very destructive very quickly at indoor distances, a little bit of wiggle room with the aiming m, and less risk of overpenetration than something like a rifle or a big caliber handgun.

A 12 gauge pump shotgun is actually the only firearm in my house(in the US), and I got it over 30 years ago. I kind of want to get a 9mm handgun, but it doesn’t feel like an immediate need given the shotgun.