In the fall of 2018 I came across a deal on a P229 "Red Box" pistol, law enforcement trade-in sent through the factory for refurbishment to "as new" condition, shipped in a red box with manual, 3 mags, and one-year Sig warranty.
Mine is early 1990's, German-made alloy frame, .40 S&W, standard DA-SA-decocker. At that time MSRP for a new P229 was $1087. I bought mine for under $400.
For those not familiar with the Sig line-up over the past 30 years or so, the P229 is a compact version of the P226, which evolved from the P220 series. Both the P226 and P229 have been chosen for several US military uses. The P229 has served with US Secret Service, federal sky marshals, and numerous other law enforcement needs. In addition to .40 S&W the P229 will be found in 9X19 and .357 Sig. An interesting option exists with the .40 and .357 Sig versions being easily converted to either caliber with nothing more than a barrel change, all other parts (including magazines) being compatible.
My prior experience with Sig pistols included a P6 9mm (German police surplus) and a P230 .380. Both were excellent pistols, and the P229 met the same quality standards. Almost boringly reliable with any factory or reloaded ammo and very accurate. Controls (slide stop, mag release, decocker) are well located, easy to use, and become intuitive with minimal training/experience.
The P229 is (literally) a handful. I have mid-sized hands with fairly long fingers and I can handle it well enough, but those with smaller hands may find it difficult. This is not a complaint against Sig's design; the same commentary can be offered for double-stack pistols from many manufacturers, including S&W. The P229 dual-recoil spring design requires considerable strength in the hands and arms in operation. Loading the magazines can also be a chore due to very stout mag springs (I found the Maglula loader nearly indispensable).
.40 S&W ammunition is a subject for another "caliber wars" discussion. Like it or hate it, it is what it is. Personally, I find it to be a good choice, but I prefer handguns chambered for cartridges beginning with a "4".