currently a tie for me between:
The Hydra: pure brute force, and I just love how Chris and Wesker hold it!
S&W500: gotta love the handcannon, powerful, slow and one heck of a lot of fun to use ^^
I'm also very fond of the good old colt python from RE1, the classic scarce ammo with insane fire-power that started it all ^^