Gonna dump some useful and stupid macros here. Feel free to post your own.

My item sort macro. It sorts your armoury chest and inventory. Give it a second to complete:

/isort condition armoury category
/isort condition armoury lv asc
/isort condition armoury ilv asc
/isort condition armoury perception asc
/isort condition armoury gathering asc
/isort condition armoury control asc
/isort condition armoury craftsmanship asc
/isort execute armoury
/wait
/isort condition mh category asc
/isort execute mh
/wait
/isort condition inventory category asc
/isort execute inventory

"Thank You" macro:

/p                  ○         ♪         ♪
/p             /\__\__/\        ♪
/p            /                 \
/p        \ ( ﾐ ⌒ ● ⌒ ﾐ) /
/p   ♥ ♥ <wait.1>
/goodbye

Cooldown reset timers (nice for progression when you're wiping constantly. Just substitute your CD's):

/p       -------- CD's ----------
/p Hawk's Eye: <recast.Hawk's Eye>
/p Raging Strikes: <recast.Raging Strikes>
/p Blood For Blood: <recast.Blood for blood>
/p Internal Release: <recast.internal release>
/p Battle Voice: <recast.Battle Voice>

PvP skill reset. Substitute the skills you want to to put points into. It also takes quite a bit to finish so don't hit any other macros for about 20 seconds after starting it.:

/micon "Soul of the Summoner" item
/apa clear
/apa action "Purify" 1
/apa trait "Enhanced Intelligence (PVP)" 
/apa trait  "Enhanced Intelligence (PVP)" 
/apa trait "Enhanced Intelligence (PVP)" 
/apa trait "Enhanced Vitality (PVP)" 
/apa action "Wither" 1
/apa action "Wither" 2
/apa action "Aetheric Burst" 1
/apa action "Aetheric Burst" 2
/apa action "Aetheric Burst" 3
/apa action "Misty Veil" 1
/apa action "Misty Veil" 3

Fishing auto Hook/Mooch/Recast. One button fishing!:

/micon "Cast"
/ac "Cast" <me>
/ac "Hook" <me> <wait.9>
/ac "Mooch" <me>
/ac "Cast" <me> <wait.1>
/ac "Mooch" <me>
/ac "Cast" <me> <wait.1>
/ac "Mooch" <me>
/ac "Cast" <me> <wait.1>
/ac "Mooch" <me>
/ac "Cast" <me> <wait.1>
/ac "Mooch" <me>
/ac "Cast" <me> 

Tank pull countdown macro. If you tank, please, PLEASE use something like this in endgame content. Highly customizable, but this is what I use:

/p <se.9> Pulling in 10 <wait.2>
/p <se.9> Pulling in 8 <wait.1>
/p 7 ... <wait.1>
/p 6 ... <wait.1>
/p 5 ... <wait.1>
/p 4 ... <wait.1>
/p Pulling in 3 ... <se.16> <wait.1>
/p Pulling in 2... <se.15> <wait.1>
/p Pulling in 1... <se.4> <wait.1>
/p PULL! <se.7>

I'll add more as I come across/think of any.

Crafting macros are a whooole different beast. I have a shit ton of them. If anyone is interested I can post some.