For tanks and DPS, they're hardly ever worth the effort. Healers should have macros for focus target and mouseover healing.

Outside of skill based macros, macros that have chat alerts built into them are very useful; such as a WAR with a macro on berserk to let the WHM know they'll need an esuna soon.