When dealing with a number of conditional triggered spells, macros will literally "gets in the way" on the field of damage dealing, if you know how use all your skills.
Yes, for some custom lazy-mode things are useful, but aren't so much game breaking, imho.

I found them very useful to let party know what you are doing. Just to make an example, I macroed BRD's Ballad to let mana users know I am casting that, making a notice in party chat and putting a X mark over myself, to let them find me immediate.

Another good use is "creating" a new spell that is a mix of some others. Pet micro-management rocks!