It might not be my favorite, but I think the best weapon I have ever had on any game was called the Anal Probe on Destroy All Humans.
It made the human's brain come out their butts.
Personal / real weapon, I love Nunchaku. I have been practicing with them for years... I love any weapons that require a high level of skill and style to use effectively... So guns are totally out. No style at all.