it all depends on the job. i would never use macros with my monk, just because the cooldown shortens and you cant effectively take that in consideration. on my BLM, i use a cooldown to go from blizzard3 to fire3, with a few moves between.

an old fc mate macroed all of his DoTs and he was arguably one of the best dps we had