Michael Mann movies tend to get this right, Heat and collateral have really decent gun sounds. Turns out they are very loud.

Edit: just noticed you mentioned heat already, I need more coffee…

Just watch "that scene" from Heat again - it's like a double espresso.