I think it's one of those tools that everyone has their own niche use. These are for Home, not for Shortcuts or Personal automation, but my wife tends to leave the floor heaters on. So I have an automation that turns them off at 10am and midnight. I get home after dark, so I had my front porch light turn on at sunset and off at midnight. For awhile my garage door opened onto a busy street, so we often left it open. I hadn't automated it, but I wanted either for it to automatically close or message me if it was open for 30+m and have the option to close it remotely. We have room heaters in my young son's room. It would be nice to remotely control that instead of going downstairs (thankfully his baby monitor shows the room temp). Most of these could be addressed with a manual device, but the lack of friction really helps--until your network goes down.
As for Personal Automation, I've heard others text their spouse every day as they leave work. Now they can do that automatically with an ETA.