A good start-

Zwave and zigbee are 100% local by design.

Anything running an esp chip is usually flash able.

Check home assistants integration list for things you are considering buying.

Cloudfree.shop has a lot of local only devices