I'm enchanting my first weapon (a katana for my ninja). I'm only level 5, so I only have access to lesser spirits. This is what I came up with:

Geki (Katana)
Absorb Health 6pts
Absorb Magicka 6pts
Soul Trap 1 sec

It's a basic regen weapon just because I couldn't come up with anything more clever at the moment. What I'm wondering is what other people have done for interesting enchantments. I don't mean some kinda uber-powerful insta-kill weapon, just something creative that fit the theme of a character but was still generally effective.

One of my characters used a sword enchanted like that for the whole Main Quest. We named it "Vampire Katana" for its health-stealing effect. Just pair it with Azura's Star, to keep it fed, and you've got a winner.

Well, yeah, it's a powerful weapon, but it's a little more power-game-y than creative/character-driven. I don't plan to keep it for long, just until I get another katana and can think of something more interesting.