For me the most “woa” thing about LISP and its macros is that code is data, and data is code. The representation of a (nested) list is exactly the same as actual code, and using macros, I can manipulate it as such.
That is pretty profound, and I still have yet to find a language that just makes it so simple and elegant as with LISP.