Roland Deschain, the Gunslinger, has a pair of revolvers made from the metal of a shattered Excalibur.
Karl Zermann (Ozo) from Tannhauser has a demon-possessed Borchardt c-93 that can shoot around corners.
Hellboy has the Samaritan, an enormous 4-shot revolver made from melted-down church...