"Reality": Flame thrower, Mini-gun, Sniper rifle, shotgun, Wait... I'm just listing the weapons of Team Fortress 2. MGS1's Nikita was excellent (still waiting, Hideo) though the Railgun was good as well.
Fantasy: Gravity gun, Zelda's Hookshot (grappling hooks in general), Voodoo doll (Blood PC),
(non projectile: Lightsaber, Chainsaw, Nuncucks... aaawww yeah!)
As for rifle's like AK47, M4, Garand, they are too damn similar though if anything i'd say i love iron sights.