Smart switches and local automations are the key, not smart bulbs in the cloud.
Every light in my house is smart in one way or another, but if HomeAssistant and my internet connection both went down, basically everything would still function totally normally. Light switches would still turn on lights, etc. They'd just lose their voice control and wouldn't be turned on by motion sensors, etc.
I do have some smart bulbs in the house, but they're in accent lighting (pendants, etc), they run 100% locally, and they're turned on and off by automations that are triggered by physical light switches. For example, you turn on the main kitchen lights with the smart switch, and that triggers the pendants to turn on. Its reliable enough that I've only seen the bulbs miss a trigger or get out of sync twice in two years, and toggling the light switch and extra time fixed it both times. If the bulbs ever had a network issue (which they haven't), they're accessible without a ladder or much fuss, and can be easily unscrewed/reseated for a power cycle.
My family doesn't share my interest in home automation, but as long as everything works reliably and in an intuitive way, they're fine with it.