You will not go wrong with a P229 and they have several models to chose from - I like the looks of the Enhanced Elite. I would have tried to talk you into a 1911 in 9 mm, but most of the ones I would have suggested run more than the Sig.
My only catch with the 1911 is the cost.
I would again have to echo kiln.The Xd's are worth a look at.I just bought a XD45 and love how well it works(normally im a glock fan).Im getting better groupings then with my glock.The XD service or XDM pistols are both really good pistols with high capacity and they're comfortable...at least to me anyways.
I'd check them out at least and see if you like them. They're pretty affordable and would serve your needs well.