I’m using openHAB instead of HA for the tinkerability, but the new versions are pretty power user friendly
My battery powered Zigbee devices last at least a year without needing a recharge/replacement, which was a huge selling point (door/vibration sensors, temperature, etc), although zwave is similar if I understand correctly. Most of mine are on year 3 now and probably need new batteries soon.
My order of preference would be Matter, Zigbee, Wifi, and Bluetooth being a last resort option. Z-wave isn't on the list only because I decided against getting a controller for it.
I love that we have options like this.
They're all plugged into wall power all the time, and powerline Ethernet works fine.
What am I missing?
When I have humidity/temperature, light, motion, etc in every single room how many freaking power points am I meant to have in my house, aha. Maybe American houses have walls absolutely studded with power points but most other places don't.
Most of the remotes switches, sensors, and some others are all battery powered and last at least a year without needing to be changed.
In fact, they would be largely useless or cumbersome if they needed a wire.
I could make all this computer controlled over a home server if I wanted to, but what's the point?
My wife said the same thing as you at first, and originally had no desire for any of it.
Instead of buying dimmer switches to replace the on/off wall switches, I got dimmers that go in the gang box behind the existing switches. I did this for her, because she preferred a real switch and now we can on/off with a real switch or control brightness/on/off with voice, app, or zigbee remotes.
Since I did this on all our wall switches, my wife went from using the real switches 100% of the time to now around 0-5% of the time. When we're away from home she always makes a comment on how annoying it is to NOT have it.
Asking for a brightness change while watching a movie or cooking with dirty hands, automatically tuning the lights to something warmer at night and brighter during the day, forgot to turn something off and you're already in bed, automatically turn on the lights inside the front door when we open it with an arm full of stuff, having energy monitoring, virtual 3-way switches without any re-wiring, adding additional lights to switches that don't have real switches, controlling the TV without a remote, the list goes on.
All of my lights, outlets, and dozens of other niche things, never connect to the internet, and everything is fully functional when there's no internet connection.
Home Assistant with Zigbee devices is fantastic for avoiding vendor lock-in[0]. EspHome and Tasmota fill in nicely for if/when you want wifi devices.
[0] https://zigbee.blakadder.com/all.html