You can have manual light switches and home automation. I have exactly that, but given I built a new house with KNX integration. All light switches are physical switches and can on/off and dim the lights. The only difference is, they are not hardwired to the lamps, instead they go to the KNX machine. So if I want I can always decide what switch does what.
I have a singular smart home platform with one exception: my Dreame cleaning robot. Everything else is either integrated into KNX (lights, appliances, pool, window blinds, etc.) or Ubiquiti (cameras and doors).
But again, new building and I made the mission clear: everything has to fit into this system. Was an interesting work for the electrician ;).