This has to be the best
(UT2K4 flak cannon)


And the following are my faves
(Halo MA5B)

(Halo magnum C model)

(MW2 Scar-H)

(Nightmare's sword)


Oh, and this gun from a game I think was called Armed and Dangerous or something.
Anyways, it shoots land sharks.