I like mid-long range weapons that require precise aiming, like the pistol and sniper rifle from Halo:CE.

Some of the classic Zelda weapons are fun too, like the sword, bow and arrows, boomerang, etc.