Can anyone give me an instance/book in which magic is not saying a bunch of latin words and things happening subesquently?
Skulduggary pleasant. I think that might be how you spell it. Great young adult books. I would call them young adult anyway. Sorry if that isn't what you're looking for.
Check out The Golden Bough by Sir J. G. Frazer. It's nonfiction, and THE classic study of magic and religion around the world. There's so much more in there than just abra cadabra magic.