We have an alexa in every room, mainly using it to control lights and fans. I cannot believe how dumb the thing still is during the ai boom. I also get extremely pissed when the Internet is out (fiber modem died a couple weeks ago) and it won't work, which is still ridiculous.
What's a good replacement without being tied to someone's connected, listening devices? Something that just runs on the local network and nothing updates unless I update it.
I use Hubitat which is zigbee and zwave (and now probably has more types of connectivity). BUT I use Alexa dot2s to interface with Hubitat for voice control (Echo, turn off all downstairs lights).
What I'm seeing the most of lately is Home Assistant. I don't know much about it, but if I'd start by checking out HA if I didn't already have Hubitat.
ESP32-based systems are coming on strong --but I don't know how mature they are.
In the end, it's the availability & cost of non-proprietary, actionable devices (wall switches, receptacles, motion detectors) that make your system. A gee-whiz hub doesn't do you much good if no one makes the device you need or it's $100.
+
Hubitat (I run a C7 model, current is C8 & C8 Pro) is rock-rock-rock solid. Absolutely local once set up. Truly does not care if the internet fails. Good online community. Inexpensive.
Have you looked into Aqara? That's my brother's weapon of choice