Throughout my D&D Dming "career" I've come to find the following spells annoying and troublesome for a variety of reasons:
Charm Person, Magic Missile, Sleep ,Lightning Bolt, Fireball, Invisibility and Raise Dead.
Not a huge list really is it? Some of these spells are too powerful for RP scale dungeon adventures in my honest opinion, some are world changers and some are used to death.
Charm Person: This one has been discussed to death in RPG land (so of course I have to talk about it here) folks are always in favor of gimping (or nerfing) this spell. Folks claim it wouldn't compel someone to do something they usually wouldn't or risk their lives. Really? Come on folks this is a game where people defy death 5 times before lunch with drinking buddies they met in the local tavern, seems to me there are a lot of dangerous things the victim if a charm person spell would be willing to do. Not to mention the earliest versions of the spell clearly put the victim under total control of the MU.
One problem problem with Charm person is it's duration, it's lasts too long. In it's original version it lasted until dispelled. Greyhawk added a new save based on the recipients intelligence score which gives those of higher IQ a greater chance of freeing themselves by lucky save, but it still has the potential of lasting forever.
So total control and last almost forever, it's too powerful. Don't screw up the spell bump it up to 2nd or 3rd level.
Magic Missile: once upon a time this spell didn't even exist in D&D. In greyhawk where the spell was introduced the spell did 2-7 points of damage. and there was an additional 2 missile every 5 levels the MU has attained. No mention however as to whether or not a hit roll or saving throw is required. In the holmes edit of basic the spell requires a hit roll. In AD&D no hit roll is required , it has been downgraded to 2-5 points of damage and for every 2 levels over 1st an extra missile. Auto hits? At 1st level? A 1st level spell that hits almost any monster really. No hit roll, no save...me no like.
I say require a hit roll, damage 1d6+1 and a new missile every 3 levels (2 at 3rd, 4 and 6th) or possibly bump it up to 2nd level and retain the auto hit.
Sleep: in it's original version this spell put mobs of critters to sleep, with a different range effected by HD. But seemingly allowed a save. In greyhawk the sleep spell has no save. Why wouldn't a MU pick this spell? In AD&D an area of effect is enforced but it still impacts a lo of critters. we find out the targets can be kicked ans slapped (wounding will wake one up but one can be killed outright will sleeping under influence of this spell) awake however, still no save.
Clearly by now I'm not a fan of no-save spells. Allow a save otherwise it's a party killer that also encourages too many elves in a campaign. No auto killing unless one spends a whole round adjacent to foe killing a single foe. Run up to attack and it's a damage roll and they begin waking up. I also recommend letting this spell work on just 2-16 total HD of foes regardless of HD and if a single high level target is the target of this spell let it function. Bump it up to 2 nd level if doing so however.
Invisibility: lasts too long and is simply too good for a second level spell. Bump it up to 3rd because there are certainly situations where I'd give up on a 3rd level spell for invisibility and when judging new spells and considering spell level that's always a power gauge.
Lightning bolt: Originally a pretty gimpy area of effect but it's doubling back feature was pretty cool. However, does the doubling back require targets to make another save? In AD&D the spell range and effect is alterable by caster to be 1/2" wide or 1" wide. I've seen the "bounce" used to make billiard ball style lighting bolts down corridors, been guilty of allowing it myself.
So no billiard ball shots but to require the bounce back towards caster. Someone in the area of the bolt ht twice has to make two saves. If either fails they take damage as normal. Anyone in metal armor saves at -4, because it's a cool twiddly bit that adds reason to use this spell instead of fireball.
Fireball: originally "A missile which springs from the finger of the Magic-User. It explodes
with a burst radius of 2" . In a confined space the Fire Ball will generally conform to the shape of the space", in AD&D it was a dungeon nuking volume of roughly 33,000 cubic feet . Note however in AD&D "The magicuser points his or her finger and speaks the range (distance and height) at which the fireball is to burst. A streak flashes from the pointing digit and, unless it impacts upon a material body prior to attaining the prescribed range, flowers into the fireball"
Argghhh...33,000 cubic feet, that's annoying as all get-out! It's 33 10' cubes, that's a huge area in a dungeon. No one ever seems to note the chance of the spell detonating early on an impact however.
Fireball screams out for a hit roll, treat it like a grenade like missile. It also begs to be free of the 33,000 cubic feet area of effect. Stick with a radius and leave it at that. If it's a powerful enough fireball to burn through doors and expand to full area (in distance only not cubic volume) of effect let it do so otherwise stay away from the expanding dungeon nuke.
Raise Dead: oh boy, this one should be a biggie and it should have social consequences. There should be a physical and social taint on those who receive this spell, longer it takes to raise someone the more obvious they were once dead, impose a CHA penalty of -1 for each day between death and being raised (maybe be kind and give a 3 day safe period). Do you really want to exist as an unworldly/undead looking thing even if not truly dead? This will cut down on royalty and nobles staying in power thanks to having high level clerics on hand and not totally disrupt society.
Some folks have cool raise dead complications tables that may be worth using, do some searching.
Just a few rants and a few ideas for dealing with spells I see used too much or in an annoying fashion.