I also like being able to sequence the set of several lighting, audio, and video operations that sets my theater room up for various uses. I like being able to quickly check the house temp and tweak the thermostat from the other side of the house. And I like being able to turn whole rooms on and off at once, or to set their light dimness and color for my use of the moment without getting up or fiddling with my phone, etc.
I especially like the routine that does a sunrise wake on my bedroom lights; turns off my brown noise machine a minute before my alarm since sometimes that will peacefully wake me without having to hear the beep; chatters jokes, news, etc, incessantly at me in the morning once I dismiss my alarm to make sure I actually get up; then automatically shifts into whole-house Sirius XM to play hard rock as I start my day.
And say what you want, I like being able to ask the thing over my shoulder what my office fan 5 feet behind me is set to and change that while coding and still looking at the screen, rather than stopping, screwing around with a cheap remote control and trying to see a little LCD from across the room. Like I said, I'm ADHD. If I stop to do that, who knows when I get back on task again.
I agree for simple "turn on a switch" tasks they're way overkill, but for actual automation (and perhaps accommodation) these devices are useful, especially once you start replacing ALL your environmental devices with controllable ones. It's more a question as to whether you can leverage the automation.