Here are my contributions...
Alter Self 1/2 - curses caster so that he/she take alternate form when splashed with cold water, and changes back when splashed with hot water.
Bull's Cunning - gives target all the intelligence of a bull, along with the temperament. Helps if the caster doesn't wear red.
Bull's Grace - gives target all the dexterity of a bull. Not to be used in shops with chinaware or glassware.
Charm Self - turns caster into a narcissist (if not already one to begin with).
Create Grateful Undead - summons band of undead bards, along with hordes of groupies and followers.
Evard's Naughty Tentacles - the less said about it on a public forum, the better.
Faerie Pyre - summons group of faeries (size of group depends on caster level), which spontaneously combust.
Flaming Blade - summons a rather colorful (and well-dressed) swordsman.
Flare Clothes - summons clothes from the 70's for everyone in the party.
Forbidden Dance - compels caster to dance in a seductive way. Reaction of party members and nearby characters and creatures left to other players and DM (as appropriate)
Not-so-helping Hand - creates a phantom hand that leads nearby hostile creatures (usually ones with the highest CR ratings) to the party.
Hide From Self - subjects caster to self-delusion.
Horrid Writing - reduces caster's spellbook to a story worthy of Snoopy's writing abilities (or lack thereof).
Mage Finger - lots of fun at bars...even more so in private!
Repel Party - subjects caster to various foul odors.
Self-righteous Might - subjects caster to self-delusion centering on his or her cause in life. Rather popular in The Theocracy of the Pale, as well as mysterious organizations such as RIAA and MPAA.
Slay Non-living - kills the dead. Useless in dealing with undead.
Spike Beverage - lots of fun at parties, particularly ones where alcohol isn't served for one reason or another.
Statute - a mysterious voice recites out loud the laws that the party has broken to date. Caster level determines how many laws are recited per casting.
Stone Person - subjects target to intoxication. Caster level determins just how intoxicated the target is.
Suggestion, Bad - compels caster to follow whatever bad suggestion comes to his or her mind.
Telegraph Moves - tells the enemies of a party exactly what moves they'll make against them in advance. Caster level determines how far in advance enemies are told.
Wall of Jello - summons rectangular block of a sweet and edible gelatinous substance. Is more often used outside of battle (usually in private) than during it.
Whirlpool - summons one or two men in blue uniforms that have nothing better to do, and just stand around since their battle skills are quite limited.