Rocket Launcher from Halo 2 (with lock on), jus cos its fun wen ur mate thinks hes the dogs bollocks, flying around in a Banshee, and u stick a rocket up his arse!
Telekinesis in Bioshock, just for the sheer fact you can pick up splicers and throw them at others.
Lancer in GOW, Chainsaw...