Anybody know of a smart light socket out there to screw a bulb into that is either Zigbee or Z-Wave ... NOT WiFi? I don't think such a product exists.
Others here have looked for the same functionality. I don't think it exists.
Can't speak for compatibility.
https://products.z-wavealliance.org/products/2355
Currently unavailable
https://www.amazon.com/Everspring-Z-Wave-Screw-Socket-Module/dp/B00G3OEW9C/
Also for zigbee their is this, also be warned I can't speak for compatibility.
If I were a betting man, which I am, I'd bet that one would pair as a generic zigbee.
If you are thinking about getting a smart light socket, wouldn't it be easier just to get smart bulbs?
I'm not sure what you will gain but then again I don't know your use case.
I have a specialty LED growlight bulb which I wanted to control but not wanting to modify the light switch that controls it. That Zigbee one above might do the trick.
I got one and been testing it for two month now, it works perfect with hubitat.
These work great for me, they are zigbee and pair right up with HE:
Those look promising. The Terncy socket I bought (with the hope that I could get it to enroll) turned out to be a bust.