I picked up a P229 Legion 9mm about 8 months ago. I had some issues out of the gate with it (crooked front sight, then flaky finish) that SIG promptly took care of and compensated me for. It has since had a little over 4,000 rounds through it with zero malfunctions.
The 229 has quickly become my favorite pistol. I've traditionally been a Glock guy and still own a G19, but it just doesn't get shot much since I got the SIG. I shoot both of them about the same as far as split times and scores go, but the P229 is just such a more enjoyable "experience". I genuinely enjoy taking it out to the range. It's also cool to see other SIG shooters, because they are usually enthusiasts that enjoy talking SIGs.
My 229 is also, I think, the only pistol I've owned where I don't plan on changing a single thing. The trigger is already very good, the grip and finish are beautiful, and the sights are fast but still allow accuracy at 25 yards and out. It really doesn't get much better. The only downside I can think of from a purely utilitarian point, is that a Glock/M&P/320 will do about the same thing for half of the cost. But then they are also plastic and hideously ugly .
Just a heads up on IDPA: as far as I know the 226 SAO Legion will not fit in the IDPA box. It's fractionally too wide at the ambi safety.