Automating everything we repeat is not worth it. It depends on how often we repeat it and how long it will take to automate.
A sensible view on automation: Be ok with doing some things manually, ever so often.
This is what tips the scale for me: The emotional anguish of repeating the same step, again, and forgetting the previous step, again.
Then automating rapidly becomes worth it.