I love my 9mm p229. It's comfortable, accurate, and reliable. I also think Sig customer service is great, and you can take great courses at the Sig Academy. My primary complaints are that classic Sigs are not very good for concealed carry. Others will disagree, but I think they're too heavy and bulky. I know they are releasing new models now targeted at CCW, but I like the classic guns and they have a proven track record.
The p226 is my favorite. I hope the p250 takes off because it is very forward thinking, but I haven't seen a lot of them around. I know they were recently adopted by the Dutch police, which is a good first step.