I've always liked the idea of them, but in play they've either been an annoyance or weak comic relief. When you whip out Blackrazor you want to devour some souls, not have an argument with the weapon twice as smart as you.
I'd love to hear anecdotes of intelligent weapons that worked in play.