{{Lore Link}}: This links to the gamespace (or parent) article if it exists or the Lore article otherwise. It is almost never correct to use this outside of Lore space. Instead, use a standard [[Lore:...]] link. Lore Link's main use is in transcluded Lore-space books, where it's typically desirable to link to that gamespace's article, if it exists, rather than Lore. An example of this would be Lore:Ascadian Isles. In Morrowind space, you want to link to Morrowind:Ascadian Isles; in any other namespace, it makes more sense to link to Lore:Ascadian Isles.
[[Namespace:page]]: Link directly to the namespace. This should be used in cases where the namespace will always be the same and either the page already exists or a red link is desired rather than linking to the Lore article.
[[Lore:page]]: Always link to the Lore page, regardless of whether any gamespaces have a same-named article. This is most useful in cases where you want a broad overview of a subject rather than the local version of the article.