I don't play many games with gun sound effects, and I'm not exactly knowledgeable on what a real gun is supposed to sound like when it's fired. Keeping that in mind, my favorite game for gun sound effects is probably Half-Life 2. I always liked that sort of flat "crack".
The following video can probably explain it better than I can.
The following video can probably explain it better than I can.