Totally agree on the macro front !

I use them to do compile-time code gen from Omnigraffle and iThoughts files.

Definitely a super power but probably one that only works if you're the sole developer. Macro magic in a team environment is problematic.