I am an avid pistol shooter in real life. I own a .45 revolver, a .45 automatic and a .380 automatic. Therefore, I love pistols. Espically the way overpowered pistols in Resident Evil games. And for some reason I love the Barret .50 cal sniper rifle from COD4, since it is a real life weapon and is damn sexy to look at. However, I am displeased with the game's portrial of the weapon. I use it as my only sniper weapon in that game and on more than one occation, it has taken 2 bullets to bring someone down (I'm not a great sniper, I just enjoy it). In real life, that rifle would put a hole in the earth. I don't care where you shot someone with that thing, they are gone, period.
I also really like the Redemer from UT3. A guided nuke. You can almost see the person's face before it hits them, that "Oh shit" look is priceless.