Having shot several sig pro's, and being a factory trained armorer for them, I can provide several insigghts.
Generally, the SP 2009/2340/2022 are very reliable and have relatively smooth axctions compared to the competitors. They are accurate and lightweight and are very corrosion resistant. They also hold up well and have a fully supported chamber in all calibers (IMO a big advantage over the glock 22 and 31). There are several things you should know however:
1 the trigger pivot pin is held in place by a plastic snapper sleeve which is a single use part, so, if you detail strip the frame, you will need one of these on hand. They only cost a few cents each, but if you are out it can be annoying
2: some folks find removal of the slidestop hard on new guns. they loosen up over time, but initially ity is pretty tight.
3: It is virtually impossible to get someone to do a trigger job on the weapon (except the factory custom shop) the trigger box is a modular unit which is very very dificult to break down, and I know of nobody outside of exeter who will try.
I would recommend is highly, it will serve you well and I have never seen one malfunction of the 20 or so we have in service in my agency.