The old subsim link only directs to the old version of LSH3.
The link to Urmelgames' site is the new LSH3 v4.
You can also find it through
SHMF
It enhances the game from another perspective than the other supermods. And it includes elements such as unique units, terrain changes and different gameplay, which you won't find elsewhere.
But, I'm not the right one to explain in detail. You could ask the same question in SHMF, and I'm sure rowi58 will come up with a larger list. Or you could read the manual written in English and available as pdf.