"Unreliable"
This sword is 'blessed' with healing magic. On every attack, the DM makes a secret roll 50/50. On a pass, the sword functions as a normal +1 magic sword. On a fail, the blade turns briefly into curative light, HEALING the target for the damage rolled instead of hurting them.
Blackburn
This +2 sword is enchanted with a stronger than normal Flaming Burst effect. On a hit it deals +2d6 fire damage, and on a Crit it deals an ADDITIONAL +2d10 fire damage. The wielder ALSO take all this fire damage (apply resistance and weakness as normal).
Similar effects for any element type (FrostBite, Bone-Shaker (thunder), Tingler (Elec))
the classic Back-Biter
A +1 weapon, on an attack roll of natural 1, the weapon warps, wraps around, and stabs the wielder in the back. This deals the weapons normal damage +1d6 precision(backstab) damage.
Wheatly the Sword
This is a sentient sword. It can talk. It's got a standard +1 enchantment, and two variable enchantments. The first is that it can change shape, between a Sword (Slashing), Spear (Piercing), and Club (Bashing). The second is that it manifests an energy aura, Fire, Cold, Electric, Acid, Thunder, Necrotic, or Radiant. This deals an extra 1d6 of that type of damage.
The problem is Wheatly is very stupid, will not listen to you, and automatically picks the WORST combination of form and element for fighting any enemy.
"Clearly we need Flaming to fight this Fire elemental! Haven't you ever heard fight Fire with Fire?"
"Slashing is BEST for fighting Slimes!"
"What do you mean 'Turn into a Club we're fighting skeletons?' I think I know a little bit more about skeletons than you" Turns into a spear.
EDIT: I forgot one of my all time favorites that actually saw use in a game.
The Sword of Reincarnation
This was a +5 Longsword, enchanted at great cost with the effect of the Druid Spell Reincarnation. Any creature slain with this sword is IMMEDIATELY effected by Reincarnation.