Yeah Chris does great work.
I think if people have great macros they are already sharing them. The best one I made on my own I shared as well. (Which is a filing macro). The only thing I have changed about it is the key to trigger it since I am now using Karabiner and also to add additional folders to the macro.
You might want to take a look here:
But also look in the "Macro Library" Section.
The one I use several times a day, everyday is here: FileAssistant
It's not a single macro though but I continue to expand it and it's been extremely useful. To explain how it works, you create a macro to move a file to a folder. You duplicate that macro several times using the same key combination to execute it. Using the same key combination causes it to prompt you for the specific location (based on how you named it) you want to move the file to. As you see in the example I used the same string in the name and then careful choices on what I called the folder even though the actual folder names may differ.