For a decent carry or protection sidearm, I'd buy a NIB/new semi-auto DA only pistol in .357sig, .40 or .45acp.
A compact or med frame will do okay. Night sights, lasergrips & 1913 rails are good add-ons but not required for a concealed carry pistol.
A Beretta PX4 C, a SIG Sauer DAK P224, P229R or P239 SAS, a HK LEM P2000 or P30 or a Kahr could do very well.
Carry only factory rounds too. NO reloads or hand loads.