From this page, you will be able to navigate to the various in-depth information pages regarding the spells we use to melt faces with.
At this time this information is pretty much defunct. Spells have significantly altered in patch 5.0, and the in-game descriptions are very easy and userfriendly so I don’t believe I will be needed to go in-depth about them. Consider this page a museum of the Shadowpriest oddities of WotLK and Cataclysm.
To do list: Fear, Silence, Psychic Horror