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…