If you stick around, you will learn that there are spells listed and allowed to remain simply to draw traffic to the site. They bring in people who quite simply don't know better. They are at least mostly listed in the fantasy and trick sections of the spells, and for a reason: They're merely fantasy and 'tricks' in the sense that they are not legitimate.
Some very good examples are spells to become something else, like a mermaid, vampire, werewolf, Smurf, fairy, or who knows what. Some others are about growing or changing body parts, such as growing wings, changing hair or eye color, or becoming something you are physically not. Yet more deal with time travel or manipulation, telekinesis (and other kinesis types), teleportation, levitation, actual transmutation of matter, and so much more.
Magic is limited to the laws of nature and reality.
Levitation, for example, is scientifically possible with incredibly powerful magnetic fields and very small objects (not talking about using a magnet to 'float' another object), but the human physiology is not capable of generating that sort of magnetic field. In fact, I have yet to see a person able to generate any magnetic field strong enough to have physical evidence.
Teleportation is possible through science. It takes a tremendous amount of energy to send a single photon an infinitesimal distance. The human brain, at maximum function, doesn't even release enough electricity, all of which is used for brain function at that moment, with none to spare, to start a car.
Other (parallel) universes may exist, and if the hypothesis does prove true, it will take many squares of the energy to transfer any matter or energy between them using known scientific processes. Think the entirety of the energy released in the collapse of a star being focused into a single point. Obviously this is something a human body can neither generate nor handle.
Magic also cannot literally change a person's DNA or physiology. Some things can be changed with surgery, but not just by using the mind.
Magic is, however, about subtle energy (I wish I had a better term for it) which can be used to influence the world around you, and more importantly, yourself. Personal development is a very important aspect of magic.