I agree there, go with a hammerless revolver.
Only thing lacking really is capacity. Best case scenario shots never get fired even if the gun does get pulled, so capacity doesn’t matter.
Worst case... after that first round the bad guy’s day is pretty much ruined so the followups are just to make sure he doesn’t get back up. Anymore than 3 rounds here and haven’t been training enough.
It will also never ‘jam’ or malfunction.