Okay, so a lot of my favorite non-core spells are homebrew, but hey, here ya go...
*From WotC books:
Spell Compendium
Anticipate teleport
Reality maelstrom
Revivity
Book of Vile Darkness
Whirlwind of teeth
*Homebrewed
Players' Guide to Cydra
Righteous zeal - clr 9; gain DR 5/-, 100 temporary hp, +6 Str, Cha, attacks, damage and Will saves.
Jerakai's embrace - sor/wiz 3; gain extra set of arms. This goes back to 2e imc, so I don't use the WotC version (girallon's embrace or whatever it's called).
Act of God- clr 9; retroactively negate all damage and harmful effects from one source for one round
Wall of Honey- drd 3, sor/wiz 3; difficult to pass wall of honey, clogs breathing and vision
Ivy Siege- drd 6; ivy crushes a building (conversion of a 2e spell from Complete Druid's book).
Word Lock- sor/wiz 6, brd 5; seal closure, can only open with proper word; bards can tune the lock to a Perform check of a DC equal to the one they make when casting the spell
Superior Teleport- sor/wiz 8; teleport without error to anywhere, anyone or anything, even if you don't have a clear description (ex.: "I'm superior teleporting to whoever stabbed my best friend!")
Proleptic Visions- sor/wiz 9; gain visions of impending attacks on up to 5 individuals, locations and objects of your choice; the ultimate alarm.