Many, many LEO agencies have issued it, including the Texas DPS, which I'm more familiar with. I can tell you that it's street reputation is fantastic; it's been very successful since adopted in 1998. Sadly, that agency is thinking of dumping it and joining the "Well the FBI said the 9mm was best so it must be" crowd and going to a tragically anemic 147 grain ice pick puncher. No common sense reason to. The .357Sig has shown to be a devastating man-stopper, especially when one has trained correctly with it and can put multiple rounds on target accurately and quickly. The 125 gr Gold Dot is the best of the breed, but surprisingly the Remington Golden Saber seems to be just right behind it, performance wise.
Personally, I'd stick with a Sig simply because they designed it and their guns are engineered to run it. Yes, a P229 (or even P239) is heavier than other pistols in the same class, but I doubt you'll notice that heft if the situation arises where you're forced to use it. Besides, that 'heft' actually helps tame it's snappiness a bit.
If a full size pistol is what you are going to carry, I'd strongly suggest a SigPro (SP2340 if you don't want a rail, SP2022 if you do), because it's just as reliable as the classic P series, is lighter, is nearly as accurate as a match gun, has a really nice trigger and...best of all...can be had brand new for about $400. You can do an easy drop-in switch of the .40 and .357 barrels if you want to, also.
Just my $0.02.