Lightbulbs not so much.
The only thing I wish it would do would have better multi-zone temperature and humidity sensing to know to turn on the circulation fan when the edges of the house get too hot/cold compared to where the thermostat is. Even then that doesn't require the internet, it could be done with cheap 433MHz temp/humidity probes running on button cell batteries for years.
Or to respond to the weather (e.g. start warming the house earlier coz it's a particularly cold day).
If your life is very strictly regimented maybe it's less useful.
This doesnt mean I want a cloud connected thermostat. I want something that talks to homeassistant.
Respond to the weather? Its a thermostat. Even a decent bi-metallic strip thermostat will "respond to the weather". Its not like the thermostat needs to do anything different if its an especially cold day outside, it will keep the indoor environment as you programmed it. How do you think thermostats worked before the internet?
The only "respond to the weather" idea I'd like would be to account for especially humid days as sometimes the temperature is fine but its really humid in the house. But once again it doesn't need to reach out to an API to figure out the humidity outside at some airport 20mi away, it just needs a local humidity sensor.