I find that using macros has a greater benefit for ps3 than for PC, but for certain things they can really help for both. Like stated above, as a healer I always macro my offensive abilities as <tt> so I dont' have to switch back to the tank in case he/she takes a big hit while I'm helping the DPS.