Welcome to the site.
Some spells here work, and others don't. I would suggest using common sense when browsing through them. The spells in the fantasy section are simply fantasy, and thus do not work. Spells which claim to be able to transform you/something, control the elements, and other such feats are fake.