This is another one of those types of discussions where, back when I was serving as an instructor, if someone asked me for a recommendation in carrying an off-duty weapon, especially involving make/model, size/weight, caliber and capacity, I came to refrain from making specific recommendations.
Instead, I leaned toward asking them how
they perceived their skills and abilities, and what considerations were most important to
them. Size, weight, caliber, make/model, capacity, etc. When it was possible, we'd break out something that interested them from our training inventory, or something they were considering that might already be owned by someone on the training staff.
Then, we'd go downrange and let them familiarize themselves with the gun(s), and let them run some drills. That was often enough for some guys & gals to realize they
didn't really want what they'd thought they wanted, and for others to confirm their tentative choice
was something they liked after some live-fire time.
It was sometimes also the case that somebody discovered what they thought they wanted wasn't something they could use well ... and sometimes what they didn't particularly 'like' was a gun that they could nonetheless use very well.
Well, sometimes a timer and examining the holes on threat targets may tell a different story than what we might wish to be the case.