I have to say I've learned some things from this thread...
I'm a roleplayer and I have some macros for "flavor" like a protect/stoneskin macro where I "/s I want to protect you all, please stay close." and other similar things. I only regularly use macros for big cooldowns like Swiftcast Raise and Benediction. And protection at start of dungeons. I have my aoes with macros that I use in fights for big mechanics to tell people to gather together... Not as cool as some of them, and the macros work for any big thing well enough.