Sure, I should never say never I guess. If I needed something I didn't want to make myself, and could live with the additional latency the cloud solution adds, then YoLink would be on my short list to use.
If YoLink ever made a hub that had a local MQTT server exposed without need of cloud, I would endorse it whole heartedly. Devices are well designed, a good price, and use good technology (even if it is a proprietary version of it).
They say they will add local control (and Matter) to their Hub 3. If/when they do, I'll pick up a hub and some devices and test it.
Lora radios are much more sensitive - like 30-40 dBm better than zwave 800, which is a LOT - which can help in the far distance/edge cases. Lora's modulation is also better, which makes it easier to get a successful transmission at low signal strength, but again that typically only comes into play in high interference or long distance transmissions.
Zwave LR is a very good protocol and in distances <500ft should perform (in practice, if not technically) very similar to many LoRa applications.
I do wish, however, that vendors would consider putting better (external) antennas on Zwave LR devices that are meant for outside use instead of the lame PCB ones. A few extra dB on the signal would make a big difference on many outdoor applications.