I thought this until my parents bought an expensive and fancy house. There are dozens of light switches spread all over the walls of the large living areas plus individual lamps and it's a chore to walk around and switch them all off every night or when you leave the house. I can see why automation is attractive for that, and I can see why home automation companies would target owners of fancy houses since they have the most money.
I blame the designers though. The fine grained control is completely unnecessary. If each room had only one circuit for all the lights in the room, controlled by switches at each doorway, that would also fix the problem.
Sure, I can see how automation would be useful in that case. If it ever becomes a problem I need to solve, I'll consider fancy gadgets to help me, but jumping into a complex solution to a nonexistent problem doesn't make sense to me.
I reckon that most of these deployments are done because the owner is a tech geek and enjoys tinkering, and not because of necessity. Which is fine as well, whatever floats your boat.
I blame the designers though. The fine grained control is completely unnecessary. If each room had only one circuit for all the lights in the room, controlled by switches at each doorway, that would also fix the problem.