Automation is not magic — it is just smart help with repetitive tasks. Here is an honest look at what it can and cannot do.