I programmed in Clojure for many years and now a couple in Elixir (which, though not a Lisp does have excellent macro support).

I think I wrote three macros in my time with Clojure and none with Elixir. That’s because mostly I don’t need to, I can solve it with functions.

However my work in both languages rests on a lot of macros included in the stdlib and other libraries. Those macros make my life much easier and, when you really need macro power yourself it is right there.

Writing good macros can be challenging and supporting them after even more so. So it’s a power I use sparingly. But I depend upon macros all the time.