Just for giggles I started thinking about what spells in DDO are 'the most useless' for sorcerers. Here's my rundown, but I'd be interested in hearing other people's lists and reasoning.
Mage Armor: Okay, it starts out handy... at level one. But bracers/robes/rings/whatever of Armor are common these days. And it doesn't take very long to get a +4 robe. Heck, I was looting them while still on Korthos. And even back in the day when bracers of armor were a valuable commodity, Black Widow Bracers were fairly easy to get by around level 3. And back then those would tide you over till at least level 8. So for the most part all it does is provide 4 AC when fighting wraiths/ghosts. Other then that this spell wastes space in your rather limited spell book.
Cats Grace/Owls Wisdom/excreta: Once again, here's an entire set of spells that start out useful, but are quickly made pointless by gear. In this case it's due to the fact that stat boosting gear is rather common. The Mass versions of these spells are even more pointless. By the time you can cast a Mass version of Cats Grace, for example, everyone who cares about it will already have a +4 dex item, or better.
Flaming Sphere: I want to like this spell. I really want to like it. In PnP I've used it to great effect. And yet it falls flat in several big ways. To begin with, it's save DC is really low. Which means pretty much everything will save 98% of the time. But when it does hit it does good damage, right? Not so much, no. Flaming Sphere does 2d6 damage and never increases. Okay, so spell power can increase the damage but that's about it. And then there's the fact this thing is SLOW. So slow in fact that a one legged elderly kobold can hobble faster then it moves.
Niac's Cold Ray: I'll admit, when this spell works it works very well. With it dealing 1d5+5 damage per level, with a cap of 5d5+25 it can deal some serious damage. The problem is the low save and all or nothing effect. While you can use Heighten to raise the save DC, is it really worth doubling (at least) the cost of this spell this spell?
Haste: The attack speed boost and other benefits are nice, this I'll grant you. But at 6 second duration per caster level, it's more of a situational buff. Yet so many view it as mandatory to maintain the entire duration of a quest.
Grease: In all the times I've tried to use this spell it's only caused 3 enemies to fall over. But it almost always knocks down players. Even the ability to light Grease on fire for some area damage doesn't help this spell out.
Melf's Acid Arrow/Black Dragon Bolt: While they do some good damage with no save possible, these two spells run afoul of another issue. Namely that enemies tend to die faster then they can deal their damage. If given a choice between dealing 12d6 damage over 8 seconds or 12d6 damage instantly, DoT rarely will win out. In short, it typically takes far too long for these spells to do anything useful. By the time they've managed to severely hurt/kill the monster, it's probably beaten you to a pulp. Or you could have already beaten said monster if you chose a different spell. And since they're single target, you have to spread the slow damage around, costing more SP. For damage over time, spells like Wall of Fire or Cloudkill are far superior. Now that I think about it, Burning Blood fits in with this issue too.
Contagion: Wow, this spell is so bad for DDO I'm not sure how it was considered a good idea. No, seriously! How many fights last longer then a minute? And the fights that will last for a minute or longer, how many of them will be against something that can't make the fortitude save whenever they want? This is a spell that's so situational, I fail to see when the situation would crop up in DDO.
EDIT: After messing around with Contagion-Slimy Doom this variant may sometimes be useful, maybe, due to it's effect going off every 6 seconds instead of 60 seconds. But I'm still seeing it do jack and diddly quite often due to things making the fort save twice in a row.
Anyway, that's my list of sorcerer spells I've found so far to be rather pointless. What about you guys? What spells do you consider to be not worth considering?