The one that frustrates me the most is Home Depot's HubSpace. You do not have to link the devices to the router. They can be operated by Bluetooth.
However, the app to control them cannot work without a connection to the server. It has no local device functions at all. It won't even launch if their servers are offline.
That's just next-level stupid to me. Why build in a useless option? If Bluetooth won't work without a server connection anyway, what's the point?
At some point a team of developers fought for local control. They lost but it's too expensive to rip out again. So management chooses to sweep it under the rug and pretend it doesn't exist. Stalking your users is so much more profitable.
Pretty much any vendor selling commercial appliances. SpeedQueen even gives you the choice of the old school mechanical controls. I don't know if they even have any smart consumer devices. They can be a bit more expensive but rarely break from household use.
For smaller non-appliance stuff there's CloudFree [1] which sells products from other vendors that can be reflashed with ESPHome (no affiliation, just a happy customer).
The trick is to get a ZigBee device instead of a WiFi one. It's an inherently local-only protocol and you can make your computer a Hub with a $30 stick.
ZWave is another option here too. I wouldn't recommend devices that don't have at least a "500 series"[0] chipset, but pretty much any device you'd buy today or moving forward will contain this or a newer chipset.
Shelly devices are great. They have a "cloud" that you can optionally use, but the settings (at least on the switchable plug and the in-wall energy-monitoring switches that I have) default to that cloud connectivity being OFF. They seem to be aligned with those of us who prefer local data, interoperability and despise vendor lock-in and surveillance capitalism.
See also previous discussion on https://news.ycombinator.com/item?id=39044932