Welcome! I think you’re absolutely right that thinking about how other people will interact with the home automation system is crucial. At our house, we have three housemates with all our various friends and visitors plus home healthcare workers. Finding interactions that work for everybody has been a real challenge!
BTW, there are many ways to handle the switch for a smart-bulb issue. 
As @marktheknife mentioned, One of the newest is the smart switch covers which fit in place over the existing switches. There are several other ways as well.
If you read the user guide for your smart bulbs, you’ll see that all brands say these bulbs are intended to have continuous power. You can actually shorten the life of the bulb significantly by frequently turning the power on and off to them. Plus the fact that none of your time-based or motion based automations will work while the power is turned off at the switch. So it’s better to find a networked solution that meets the needs of people to have a physical switch.
Fortunately, we have an FAQ for that: