I was recently made aware of WiFi HaLow. Official standard, ranges into the hundreds of meters. Speed suffers at long ranges of course, but still respectable (50-100kbs).
Difficult within the EU due to ISM limits.
Maybe ok for your garden camera where the authorities just don't care. But no go for any industrial usage.
Dead outside the US unfortunately, worse range than regular wifi due to being strangled by lower channel width and ridicolously low power limits. The two bulky HaLowLink routers are the only off the shelf thing with support for it, it's nonexistent as a wifi standard.
I was so excited when I discovered it a few months back after struggling for years to set up reliable wifi for outdoor robotics, only to realize we can't have nice things. The struggle continues.
Sounds like it fills the same niche as LoRa. Never heard of it though, thanks.