In the real world the only weapon you need is the AA-12.
Nothing is getting back up after getting hit by that.
But as for fantasy, I prefer the Jackie Chan types who use their surroundings as weapons.
Nothing beats grabbing whatever you can find to kick your opponents ass.
So I guess I really prefer hand to hand but would really rather use the weapons myself.