I don't get it. Might be cool in a new house with smart switches, but in an existing house, it's just a pain. We removed our Hue lights because it's so annoying that you can't use the switches anymore (as you would turn off the smart lights). We even tried working with Eve Sensors, but it was still a hassle. Smart switches make much more sense than smart lights.
We set them to only switch on when there's movement after dark, but then we wouldn't have enough lighting on darker days, or when we set the lights to always come on when there's someone, then the lights would often be on unnecessary.
Even turning the lights off was far too complicated. HomeKit does allow a timeout to dimm lights when there's no movement, but that just resulted in us waving our hands during dinner. Automations also don't bring a solution. For instance, turning all lights of after midnight resulted in people sitting in the dark sometimes. Or lights burning while there was no-one around. Currently HomeKit is far too limited and not at all smart. Nothing beats a simple wall switch. At the moment, smart lights are a gimmick.
sounds like you didn't want them to work for you...
I think like all technology, you have to want the gadget for it to be any good (for you)
I mean why would you set automations to do stuff that you didn't want it to do? not getting at you, its up to anyone their opinions or actions, but then it almost sounds like you set them to do the things you didn't want them to do and then were unhappy when they did what they were told.
for me, I wanted them, wife had an open mind. now she loves them and wishes we'd got them years ago.
for us, the benefits are different in each room. we have sensors in the areas where you don't spend long (why would you have a sensor where you eat dinner????) so hall lights and bathroom lights on short timers, kitchen on slightly longer ones. for the spare room I have a sensor for normal use when no one is staying, and a dimmer switch on the wall for anyone staying over.
we have white ambient for the bathrooms, spare room, kitchen...places where the colour isn't important. but for the open plan dining and lounge area we have colour, plus a hue go on the table. wife loves setting the colours, but we have a dimmer switch on the wall in case we don't want to shout at google home or pick up our phones to set them.
and when we go out on the balcony, the hue go gets picked up and you get a few hours of battery life to enjoy a glass of wine or too.
just wish I could fix my wifi problems in the main bathroom, as those are the last bastions of old fashioned lights, and when I walk into them or into a hotel room I do pause for a second waiting for the lights to come on then realise...