Hi @PumpedMedusa, The rage is depends on the Antenna and how much TX power you have.
To choose antenna, first you need figure out - where your nodes will be, take a look at the below image. The antenna act like a "torch" if you have more dbi that mean it's focus will be increase and it can reach more distance but the angle it have it less, like a laser.
458a3da2-175a-4968-917c-56c5a1b763f8-image.png
also, obstacle such as buildings, tress and mountains will affect the signal and deplete it.
afe5eba4-b192-4263-8596-80c912fc1f23-image.png
So, answer for you question - What is the best LoRa module to use for long distance network? - It's really depends on where you planning to put the nodes and how high you putting the gateway. Let me know know your thoughts.