In general, put off automation for anything that's not every day or month that you can't just do in a few hours , e.g.:
* Parts of performance assessment & compensation tooling
* Sophisticated recruitment analytics (especially important because with small data it's often not precise or accurate/needs manual attention)
* Provisioning new stuff that doesn't happen often: databases, clusters..etc.
* Maybe the biggest bucket of stuff in general is analytics. Often times people try to get whiz-bang end result numbers with data sets of like 100. It's almost always the wrong move to have crazy analytics abstraction layers and automation when the numbers are small.
A potential simple heuristic might be something like: if it take a day or longer to automate, you need to save at least 5 days of time in the next 6 months for it to be worth it.