You'll read a lot of illusions and wishful intentions.

In the end: LoRa is only good for very short text messages at somewhat long distance (up to 10km without special setup) and without bad conditions (obstacles on line of sight, rain/fog). There is an ongoing fight between each of the two frequencies to be used as default and this publication adds another frequency into the battle.

There is WiFi HaLow, a relatively new WiFi protocol which seems to solve the low bandwidth issues with LoRa on relatively confortable distance (likely up to 8km, same as with LoRa in regards to Line of Sight), albeit slightly less affected by weather conditions. The advantage here is permitting to send images and binary data in general, but think about something being sent at the speed levels from 2005 (which in any case is good speed for most usable things).

Then there are other relevant mesh protocols yet to mention here like ESPnow which is my personal favorite. Whereas the other two options above are exotic and with transceivers around the 50 EUR and above. With ESPnow you just need any cheap ESP32 embedded device with an optional antenna to increase range for about 3 EUR (antenna included). With that you get similar returns to WiFi HaLow with less range (about 3 kilometers max on my experiments) but cheap like heck.

To setup internet on a vast compound, WiFi HaLow might be a good investment. If you are with a constrained budget, then ESP32 is your friend. To remember, long distance is limited so if you are considering more than 8 devices exchanging heavy data, you should just go for proper WiFi long range transmitters.

Cheers, there's nothing more valuable than an opinionated overview from someone who groks the domain