I can remember one leader weap in particular that I had. I was during some Immteraction and Prayer where my character was basically crying for those fallen and actions taken IC towards his cabal, and I had a blade of shimmering tears or something like that, and even if it wasnt the best weapon to sport 24/7 I did, simply because it was MY weapon, ya know.
Recently, the leader weapon seems to be a standard leaderweapon that is descriptive based on the cabal, not so much the character.
Personally, I don't think it's that spiffy to get a standard leader weapon, spells/skills/sups is different, those are cool to get, but as far as a weapon, unless it ties into your character specifically from Role, actions, or what have you, it just doesnt have the same magic.