I bought a SIG-Sauer P220 .45 and P226 9mm back in the mid 1980s as a pair, which wasn't long after the P226 came out I believe. For the 4 years I spent in college (and maybe a couple afterward) these two guns (and a couple of revolvers) were pretty much my entire pistol arsenal, I had sold all my others. While in college I worked at Midway Arms, and had access to dirt cheap reloading supplies and shot these almost daily from my back porch!! 20,000 rounds in just those 4 years is a conservative estimate for the 2 SIGs.
Both guns have been exceptionally reliable in my 25 year ownership, and exceptionally accurate in comparison to others I've owned in the same calibers since. Both guns are also true 100 yard pistols, and will do their part to place rounds again and again onto a plate sized target at that range... SIG pistols do an amazing job of inspiring confidence in the people firing them, and making them look VERY GOOD to anyone watching them!
Now for the few (and relatively minor) "negatives"... I don't particularly like the 9x19 chambering in a fullsize gun, like ThePatriot mentioned, and because of this I've never carried the P226 as a CCW. Both the 220 and the 226 are LARGE guns, put a 1911 down beside either and their chunkyness and physical size are very apparent. The 1911 looks like a thoroughbred beside their chunky fatness... and people with small hands may have issues gripping the thick butt of the P226...
Like at least one other mentioned, check out the SIG-Sauer P228 in 9mm as an alternative. The P229, P225, and P239 are all also available in 9x19, but of the group the P228 is my favorite in 9x19. The P228 is slightly smaller in length and height, with some smoothed edges where the 226 is squared. P226 mags function from the P228. The P228 is easier for small hands to hang onto in my opinion as well. Since purchasing my P228 in the late 90s I have shot my 226 less and less.
Other options for you in a fullsize/midsize doubleaction 9mm might be CZ-75/P06 family, or one of the H&K USP/P2000 variations. I like the CZ-75 and USP-C series guns due to their control/function similarity to the 1911, although I went with .357sig/.40/.45 for those instead of 9mm
I attached 2 basic pics to this, my P226 and P228 so you can see the shape/size difference hopefully.