It's still the "obscure, magical, and freaking way to abuse the compiler it was at the beginning." It's just that the syntax for doing it has been improved. Just because term-rewriting systems are Turing complete doesn't mean one should program that way. Someday, someone may have to fix the code.
On the other hand, if you provide a full programming language, loops and all, at compile time, as LISP does, people go overboard with language extensions. LISP and PL/I were probably the last languages to go that far. There was a fad for "extensible languages" about 30 years ago, but it died out - programs were too hard to maintain.