I use macros constantly, good, bad, or indifferent. I want a little micro-management, so curing and attacking spells are based on the tank or DPS that it revolves. For example, I have a Cure Tank, Cure DPS1 and Cure DPS2 for light parties. I also have Aero, Stone, and Stone II; which are all based on attacking the target of the tank. Since my main job is healing, and I don't need to draw aggro from something that isn't directly in the tank's attention, this works well. So, I have macros that look like this:

/macroicon "Cure"
/psort
/ac "Cure" <2>