Automation - Costs vs Benefits

There is a belief we should automate everything possible.  Is that the correct approach?

Check out this brief video -