>> This exists, it’s “Matter”
Sadly, I am not sure Matter will solve the problem. Not because it cannot solve it, but because what I see in the industry manufacturers will not solve it.
I have tried several (e.g., Aqara, Google, GE) Matter products that supposed to "just work", but they did not. Every one of the devices I tried failed or made it extremely onerous to function with non-native hubs.
At 3.5% profit margin for the hardware, there is little incentive to truly interoperate. The money is in subscriptions, locking the user into an ecosystem that makes them dependent for the life of the product.
(Caveat emptor - I am an old crotchety, jaded grouch.)
I've got a few cheap Matter light bulbs that I've picked up mostly just to play with, starting a few months ago.
This fleet has several random and forgettable names on the packaging and exactly two (also unmemorable) manufacturers so far.
Pairing is a little weird: It seems to broadly involve a pocket supercomputer with Alexa or Google Home or Home Assistant or whatever, and scanning a QR code.
This QR apparently begins Bluetooth handshake between the light bulb and the pocket computer, wherein things like WiFi information seem to be exchanged.
After that, Matter devices (in my application at least) just live on WiFi.
This all happens without needing weird(er) apps, overseas clown accounts, or manufacturer-specific hardware. It is local. (Well, Home Assistant is local. The others...are whatever hybrids they are.)
And multiple local control systems (like the three I've already mentioned) can each monitor and control each Matter devices directly. There's probably a limit, but it's nice to have these things non-interactively interacting. ;)
And they seem to be working fine. Boring, even. Right now I just have all of my IoT stuff on the same VLAN/SSID as everything else because it is easy, but I have 100% confidence that these Matter devices would continue to boringly Just Work if I were to isolate them to their own VLAN with zero WAN access.
(Maybe that's something I will work on when setting everything up again after the next move.)
It can operate over WiFi/Ethernet, as well as thread and Bluetooth.
Edit: the implementation is also open source, and you can roll your own