I've got one bulb that occasionally loses connection. Then I have to turn it off on the switch, and the next time I go to turn it on with the automation I've got to turn the switch on again and let it connect first. This is not a seamless system.
My home office for example I set the Aqara switch to uncoupled and toggling it switches on/off the desk lamp, ceiling, bookshelf LEDs, Uplight and wall-strips behind my SKADIS, all of which are smart lights. Since it's _my_ home office, if HA is down and I can't toggle any of them using that switch, I'm probably not worried.
Areas of the house which are used by the rest of the family, have the spring-toggle switches and operate non-smart bulbs so they will function just like a normal switch/light if HA happened to be down and I'm not home to fix it.
It's not always a seamless system, and it varies so much in actual practice on hardware. I definitely understand why so many prefer smart switches over smart bulbs.
I also know that the silly things I want to do with colors across a day/week push me to wanting fun smart bulbs more than smart switches.
The one thing I really want is covers for some of my dumb switches, and I've seen them for cheap on places like Amazon, but haven't actually bought any or installed them, because I'm also in a situation where I don't really need SO/friend/guest buy-in/confusion-saving having people over so rarely in the last few years.