I've got one macro as a warning when something big is going to happen (i.e. stuff like fear itself in Hydra).

I can easily make a macro for an attack, but I choose not to since I don't do a ton of content that needs it. As blowfin said, people don't need to see in the chat every time I use blunt arrow. Been thinking about putting one for raise though, so the other healer can see who I got if there's more than one down.

The best use of a /p macro I've seen was a long time ago in an Ifrit normal, some guy (on the gilgamesh server if I recall) had a bunch of /p macros... They were pirate jokes! I wish I took a screenshot of his name and some of his jokes, some were pretty funny.