For me the best solution was to use smart switches (mainly dimmers) and dumb lightbulbs. People can use the switches like any other if they want, but I can still have my automations and remote control.
Agreed, people get very frustrated if they have to remember to not use certain switches. Using smart switches fixes this.