You're not missing anything, other than us using Siri :)

My point was that this new functionality, while neat at a surface level, doesn't provide much real utility.

Without custom code execution, you're limited to very surface-level tasks that should be doable with a cron+sms/email.