This is a large subject!
I can recommend a few sources, in no particular order:
"Ozark Magic and Folklore" Vance Randolph, originally "Ozark Superstition". Don't have the reference to hand. An encyclopediac account of the magical practices gathered under the rubric of Hoodoo. GREAT read.
"Magic in the Ancient World" by Fritz Graf, Harvard U. Press, Cambridge, Mass., 1997: Describes evidence for sorcerous practices in ancient Greece and Rome. I found it a good read.
"Sorcery in the Black Atlantic" Luis Pares and Roger Sansi, eds., U. Chicago Press, Chicago, 2011. I haven't finished this one yet, but it looks at the transmission of sorcerous practices from Africa to Brazil and Cuba, among others. Needless to say, much gets lost in translation . . .
"The Secret Commonwealth" Robert Kirk, New York Review Books, New York, 2007. A delightful eccentric essay on "elves, fauns and fairies" that touches on magical beliefs in 18th-century rural Scotland. Perhaps of most relevance to your query is the discussion of Second Sight, and its effects on those who possess it.
"Magic, Witchcraft, and Ghosts in the Greek and Roman Worlds: A Sourcebook" Daniel Ogden Oxford U. Press, Oxon, 2009. Again, this is one I have not finished myself. Magical practices in classical antiquity are, in some ways, pretty well documented, vide. Graf's little book supra. Two well-known examples: Plato gave a detailed-and hostile-account of magicians and sorcerers in Periclean Athens, and in second-century Rome, Apuleius, author of The Golden Ass, left a written record of the defense he offered when he was tried for the crime of magic.
Finally, this one is not concerned directly with magical practices, but discusses many of them at length: "Religion and the Decline of Magic" Keith Thomas, Scribners, New York 1971. This book is a simply marvellous read, despite its length. The chapters on witchcraft are quite detailed.
I am aware of Evans-Pritchards' studies of magic and witchcraft among the Azande, but have not read his work. I did, however, watch a Horizon documentary based on that work, which was fascinating. "Witchcraft among the Azande", directed by André Singer (1981)
To generalize sweepingly, actual magical practices in (mostly rural) societies are quite common, and sometimes persist in urban environments, such as ancient Rome. They do not much resemble most fantasy fiction, much less anything out of Hollywood. Sorcery tends to be directed towards divination, curses, and spells to bring good fortune, by means of beseeching or compelling the dead, usually by forcing them to carry messages to the underworld. Azande magic was strongly focussed on detecting witchcraft-with the wrinkle that in Azande belief, one could be a witch and not realize it. Second Sight and divination were highly prized-but could easily become a curse.
My mother had some exposure to Vodoun growing up in Louisiana; even white girls would play at Gris-Gris! A colleague of mine intervened to prevent a woman from working a curse on her father at his funeral by sneaking an envelope with a letter invoking some form of (presumably Irish) maleficium into the decedent's coffin; an example of what Graf calls "the infernal postman." I'm sure even today, in rural communities, examples may be found.
I wish you luck in your search!
