The P229 Elite is pretty, yes. It's silky smooth, yes. And of course - it's a Sig - I've put a couple thousand rounds through it in a year with exactly zero malfunctions.
If I had to pick one thing that was a downside going from a Sig P6/P225 9mm to the P229 Elite .40 - it would be that fully loaded, the damn thing weighs about 3 pounds. It has taken some getting used to - but I'm still happy with it a year later.
The heavy, double-stack .40 is honestly only slightly less concealable than the single-stack 9mm was, although I've not had a problem with concealability - but whew...you feel it after a few hours.
I've actually considered getting something smaller (still in a minimum .40 or >) to carry, as I'm getting old and fat and stuff and my back is already jacked enough without carrying a brick on my hip all day - but I'll still keep it around somewhere.
She's a bute' Clark...a real bute'.