Make it fit the character. I've got a character that uses a sanjiegun because he's a martial arts master and uses it to impress people/handicap himself.
It's hard to find unique and effective weapons because it's hard to beat the versatility of stuff like swords and bows/arrows.