There are macros that are alright. Target and focus target macros, gearset macros, place-target macros such as for healer bubbles, UI toggle macros, volume macros, shirk macros for tank swaps, macros that give buffs to your co-tank, tether macros for dragon sight or cover. I use macros to remove autofacetarget when healing but to re-enable it when doing damage, so I can turn away and still heal.

Using macros for GCDs or chains of GCDs and off-globals tends to cause problems sometimes, but if they help you with a disability or you find they are what you need to enjoy the game, you can still use them. Just be aware of the problems with them and acknowledge the downsides, like how the macro might occasionally not trigger some of the actions or how the delays between attacks may be longer than if you pressed them yourself, making it a damage loss.