Here’s my current list of magic spells, whether good/bad/neutral, and the reagents needed to cast.

Neutral:
Aqua Deletus (clean up puddles) - 1 mystic dust, 1 moonbeams
Cleanius Corpus (increase hygiene?) - 2 mystic dust
Folium Deletus (clean up fallen leaves) - 1 eye of newt, 1 mystic dust
Corpus Athleticus (get thin) - 1 dragon scales, 2 mystic dust
Corpus Fleshicus (get fat) - 2 dragon scales, 1 mystic dust
Magivestigium (transport to spot on same lot) - none
Creatum Nutrimens (summon food) - 2 dragon scales, 1 mystic dust
Expello Simae (Make sim disappear) - 1 dragon scales, 1 eye of newt, 1 mystic dust
Appello Cattus Amicus (summon cat) - 1 dragon scales, 3 mystic dust
Purgomagus (remove curses/spells) - 2 dragon scales, 2 mystic dust
Appello Simae (summon sim) - 2 dragon scales, 2 mystic dust, 1 moonbeams
Magus Mutatio (teach magic) - 1 dragon scales, 2 eye of newt, 1 mystic dust, 2 moonbeams
Tempus Interruptus (stops time) - 2 dragon scales, 1 eye of newt, 2 mystic dust, 1 moonbeams

GOOD
Benemoodus Simae (good mood) - 1 Dragon scales, 1 mystic dust
Creatum Insecto Volucris (butterflies and fireflies) - 1 essence of light, 2 moonbeams
Exflammo - (put out fire) - 1 dragon scales, 1 mystic dust
Remedis Simae (heal sickness) - 1 essence of light, 1 mystic dust, 1 moonbeams
Beautificus Locus (beautify lot) - 1 dragon scales, 1 essence of light, 1 mystic dust, 2 moonbeams
Compello Acceptus (compel to accept socials) - 1 dragon scales, 1 mystic dust, 2 moonbeams
The next five socials directed at the target sim will count as having maximum mood and relationship scores
Appello Servantus (summon servant) - 1 dragon scales, 2 essence of light, 1 mystic dust, 1 moonbeams
Benemoodus Populus (make lot nice) - 2 essence of light, 1 mystic dust, 2 moonbeams
Mactoamicus (easier to become friends) - 1 dragon scales, 2 essence of light, 1 mystic dust, 2 moonbeams
Expello Mortis (save from death) - 2 dragon scales, 2 essence of light, 2 moonbeams

BAD
Spiritus Poultria (act like chicken) - 1 eye of newt, 2 mystic dust
Mellifera Attackum (bees) - 2 eye of newt, 1 Viper’s essence
Inflammo - (start a fire) — 2 eye of newt, 1 mystic dust
Heavus Ho - (make sick) - 1 eye of newt, 1 mystic dust, 1 vipers essence
Corruptus Locus (Storm, cockroaches) - 1 dragon scales, 2 eye of newt, 1 mystic dust, 1 viper’s essence
Compello Discrepo (Compel to reject socials) - 1 dragon scales, 2 eye of newt, 1 mystic dust
Next five socials directed at target will act as though has minimum mood and relationship scores.
Servantus Attackum (Summon Spectral Attacker) -1 Dragon Scales, 1 Mystic Dust, 1 Eye of Newt, 1 Viper’s Essence
Tabula Rasa (Clear all memories and relationship scores) (Permanent)) - 1 Mystic Dust, 2 Eye of Newt, 2 Viper’s essence
Extractum amorus (Remove love)- 1 Dragon Scales, 1 Mystic Dust, 2 Eye of Newt, 2 Viper Essence
Vivificus Zombiae (Raise zombie of a Sim) - 2 Dragon Scales, 2 Eye of Newt, 2 Viper Venom

Some of these I got from this great reference/guide: http://www.gamershell.com/faqs/thesims2apartmentlifewitchguide/1.1/