I have a tendency to deep dive to magma early, so I have two macros I use a lot - one to dig stairs and a ramp spiral down, and another to carve tracks over those ramps. They are set up to go a full revolution (four Z) and end where the next one should begin, so I can hit ctrl-p a few times, unpause and watch it get being dug, and undesignate / adjust if I hit a cavern. (Early on the minecarts are the bottleneck - I set up four or five overlapping routes from my iron source pile to the magma forges to get a good amount of ore down there).
I've just done a new one to dig a housing block, but macro-furnishing it is still too error prone to easily macro-ize for me (durn bags), and migrants arrive too fast - my furniture production always seems to lag way behind the actual population.
A lot of job adjustment is needed early on, until you get enough to dedicate and backup, and then there's too many to keep busy :-) I had forgotten about the custom jobs, I'll check that out.
The workflow thing looks good, too - I'm convinced that a good part of my FPS problems are due to excess blood and items being sprinkled around after a few invasions. There needs to be an "unravel" command to turn all those troll fur socks into a big spool of yarn. Or I need to make trash compactor. Ooh, I can automate one with a pressure plate, can't I ....