I would guess a team would be so clever to develop maintainable macros.
In many places it's actually the very idea not to know how the thing is evaluated. One writes more descriptive software and does not specify execution details.
You can write unmaintainable software in many ways. Macros are a tool for code generation. How to write and use them can be learned, just like people learn to maintain large class libraries in Java.
Really, there are many of examples of Lisp code bases which make heavy use of macros and where the code was written by tens to hundreds of people.
For example much of the user facing Lisp functionality itself is macros.
Something like CLOS has much of its functionality exposed to the programmer as macros, which sit on top of functions and OOP. It's a domain specific extension to Common Lisp for OOP.
GUI libraries use macros, tools for 3d modeling use macros, ...
Whenever groups of people use code, macros are a tool to provide common language extensions. Like any tool, it needs to be learned how to use it.