Well, it's possible that there are units out there that have some variation among special uits - the original Joint Task Force up here had a bunch of RCMP involved in that, and CSOR definitely uses the 226 so there may have been some special allowance made, and I know a very high-speed individual who worked with a G17 (although I have no idea if that was even legal).
But in general, 5946s by the thousand, and they range from actually pretty smooth (if heavy) triggers to total smashfests with 3-4 hitches and pops, in each direction.
I've seen a couple of guys just kill it with them, though, which is always impressive.