This thread should mainly be about PC games.
One of the reasons I like MAFIA (PC) so much, is because the handguns in this game are fantastic. They sound great, and every bullet packs on hell of a punch. Tommy guns in this game have crazy recoil so you really learn to love the handguns. Colt 1911 and Magnum guns = YES.
Half-Life 2 has the fantastic .357 Magnum, but it's not used very often at all. Not enough bullets. A huge shame!
Max Payne also has some cool handguns, but nowhere near as awesome as in MAFIA. If you haven't ever played MAFIA, play it all costs (avoid console versions).
Post more games with awesome handguns!!