I know of one instance. During the first assault on Op MEDUSA, an officer was separated from his weapon during the fight, don't know if it was through battle damage or it went up in his vehicle or what have you, and had to rely on his pistol when he had to dash forward to retrieve a section that was pinned down.
I had to use mine to escalate force once.
I know of one MP who had to rely on his BHP to shoot one of our RG31s. Which was stationary. In the download area at KAF. Full of Canadian soldiers. But that's another story.
They were useful for air sentries aka the guys keeping an eye at the rear of a convoy. In Afghanistan if a pistol comes out it's traditionally because someone's getting executed, so they definitely take notice of them. Paradoxically, being so used to having rifles pointed at them they didn't care so much. At least that's how it was explained to me by the ANP, and I saw it borne out where the guy in the back of their pickup used a pistol to wave people away and they certainly seemed to react more decisively than with a rifle.
There was a weapons effectiveness / satisfaction study done but I can't remember where to find it anymore. Maybe it was from ALLC. Individual pistol use or anything like that wouldn't be captured in a war diary or the end tour AAR, except to record the anecdotal things you're hearing here. I personally have never heard of any instance where the enemy was actually killed with the BHP, not saying it didn't happen, just that I've never heard it. They were definitely used for self defence and "suppression," insomuch as you can suppress anything with a 9mm handgun. They definitely still have a great deal of use though, despite being so rarely or never used to actually kill someone. I never used a fire extinguisher in theater either, but you wouldn't dream of not having one around (thank jebus I didn't need it... though lots of guys did when they got IED'd)
