From the article:

"Lisp/Clojure macros derive from the uniformity of the language to enable composing the language back on itself. Logic can be run at compile-time no differently than at runtime using all the same functions and techniques. The syntax tree of the language can be manipulated and transformed at will, enabling control over the semantics of code itself. "

If you are a smaller consultancy solving hard problems, then you might need this.

The problem sometimes is: "I don't want this level of complication, especially when I am going to hand it off to other people to maintain it."

In the business world, you are not gated by your intelligence, but by the average IQ of the people who are going to maintain it over the years.