If you ditched the pistol early in the game because it wasn't powerful enough, the hand cannon might be for you. You'll be familiar with the concept if you've played any Resident Evil game. It's a revolver that's really fucking powerful. Like making-guys'-heads-explode powerful. Ammo can be scarce, but it's usually worth it.
Paddywhacker hand cannon