Shameless plug, as many others on this thread seem to have done. :) I wrote about the spectrum of macro systems available in different languages and why I think greater adoption for macros in development has been slow here: https://lambdaland.org/posts/2023-10-17_fearless_macros/

I learned a lot while writing it!