Well, I was excited about this feature but it appears for most automations, you still have to press a button that populates in the form of a notification for them to start. I was really hoping that upon my departure from work, my phone would automatically open waze (or for that matter any maps app) and start directions to my house. It's not really "automated" if you still have to give the phone the ok to perform the actions.
It does appear that there are a few automations that are fully automated. For instance, when you trigger an automation by plugging your phone into car play, there is the option to turn off "ask before running". I'm not sure why this option is not available for every automation, but the point of automations is pretty much defeated for me for those automations that don't have the option.