I have three Honeywell WiFi thermostats. I hated them at first, for all the reasons you give, and because I generally hate cloud-based stuff anyway. But I’ve come around to the idea of using both the Honeywell cloud (via the app or web page), as well as HA, to control them. You might find this works for you, too.
First, these thermostats don’t need the internet at all. You can even program the schedule right on the thermostat, although the app makes it much easier. And it’s easy to change the temperature right at the thermostat. An internet connection lets you use the app and web site, also. But even without the internet, the schedule still runs and the controls on the thermostat still work.
The HA integration brings some of that functionality to HA, too. In the case of my Honeywells, you can’t actually change the schedule from HA. But you can change the temperature or change the mode (heat/cool/off/fan.) Which is pretty much all I ever do anyway.
So I’m finding the cloud isn’t much of a hassle, and it gives me a second way to remotely access my thermostats if HA were to fail when I’m away from home. And even if both the internet connection and HA fail, the thermostats just keep following their schedule without any input.
These thermostats have been very reliable for over a year now, through a number of internet outages and power failures.