dtgreene: I could also mention the Sacrifice spell in Dragon Warrior/Quest 2; it isn't that useful for the player (since it kills the caster, doesn't work on bosses, and denies you the experience from killing the enemies), but is downright unfair when used by an enemy (if it happens, it's a guaranteed party wipe).
I had the same problem with Disintegrate spell first time I played Baldur's Gate 2. It can destroy an enemy outright, but I never used it because it destroys all items too if successful, so I was afraid I'd miss out on good loot if I use it against strong creatures, and those that I knew had no useful loot were ones that I didn't need to use the spell on anyway.
The enemy of course had no qualms about using it on me and destroying
my loot. They must be happy with whatever items they have and not interested in collecting the trinkets I carry.
It wasn't really particularly annoying though, just had to remember to protect/defend against it and reload the odd time it was used on you sucessfully (it destroyed the person completely, making it impossible to bring him back even through Raise Dead spell).