The best compromise are smart switches. Switch still manually controls the light, and smart features are always available. The downsides are that the lamp's outlet must have switch wiring, and smart switches aren't like normal toggles: they're more like push buttons so the switch isn't in a strange physical state.
(By the way, Philips Warm Glow bulbs are awesome for this. I use them in my dining room lamp connected to an Inovelli Z-wave dimmer. They get warmer the dimmer they go, mimicking how tungsten filaments work)
My current setup is a mix-n-match of all three types, using each one where it beats the other two for simplicity and predictability.