If you have no need to make a carry gun of it (and you possess reasonably sized man hands), get a P210, P220, P226, or 1911.
Okay, the $2K+ P210 may be a little over the top. But if being small and compact is not an issue, the four guns listed above are arguably the best current Sigs. Apart from the P210, all are available in various finishes, designs, and price points, and they can be had for $700-800 (maybe better). Or you can go for a fancy version and spend a great deal more.
Calibers available: 9mm, 357sig, 40sw, 45acp, and even 22lr.
I'm turned off by the P250, P290, and Mosquito.
I'd love to add a P239 (or P225/P6, P245) but they're more limited capacity carry guns.
I also like the P228/P229.
The P238, P230, P232, and P938 are all probably excellent guns...but again, carry specific.