There are a ton of really cool and interesting lore nuggets spread across the decades of 40k lore, but one I personally really enjoyed is about the Echoing Vault. A story about unspoken, indescribable eldritch horrors that at the time the story was written, was obviously influenced to some extent by lovecraftian themes.
Anyway, here is the excerpt:
The forgotten apocalypse:
There is an ancient myth attached to the cold and darkly fabled stars at the edge of the Segmentum Obscurus of an ancient war with no remembered name fought in the depths of the Imperium’s history. This war was unequalled in ferocity, and so terrible that every mention of it has been purged from the Imperial record, save perhaps for a few fragmentary references in most heavily restricted archives of the Holy Ordos, the cycles of certain Astartes battle sagas, and ancient Mechanicus data-canticles. This myth, discredited and dismissed by many pursuers of dark lore, has become an obsession of many among the Pheanonite faction. They seek both the possibility of supreme power and an apotheosis of their own desires in the ancient secrets left over from that war.
Scattered fragments of stories hoarded by heretics and other apocryphal sources tell of a great and terrible conflict, erupting by some accounts in the mid of the 32nd Millennium, a legendary time of anarchy for the post-heresy Imperium. According to the legend, a strange artefact---a vast labyrinthine contrivance seemingly spun of dust and magnetism---was encountered by Explorators somewhere deep in the Halo Stars beyond what was then as the Calyx Expanse (though other sources place it in the dread Mandragora region or even as far a-field as the Unbeholden Reaches). This great and mysterious artefact they designated the ‘Echoing Vault.’
This vast artefact—perhaps an embassy from an unknown realm of existence---unleashed a wave of horror never before seen on an unsuspecting and unprepared mankind. The xenoforms which mercilessly ravaged forth, if in truth they could be called such, were creatures of such abhorrent terror they are referred only obliquely in the records as ‘The Harrowing.’ These entities disobeyed known physical laws, and close proximity to them alone was enough to kill or drive the unprotected mind insane.
The Harrowing mercilessly ravaged all in their path, and no force could stand against them. In a few short years, the deaths of a thousand inhabited spheres---both human and xenos---were laid at their feet, along with unprecedented losses for the Adeptus Astartes and the Inquisition lead forces trying fruitlessly to check them.
According to a version of the legend favored by dark hereteks, ultimately the Holy Ordos found only a fusion of archeotech and sorcerous lore could hold the Harrowing so that the Imperium could strike; although at supreme risk to the Inquisitors that employed them. Suffering defeat, the Harrowing fled back across the carcasses of dead worlds to the Echoing Vault, where it is said the Mechanicus employed a forbidden weapon of the Dark Age of Technology to destroy their foothold and seal the breach between dimensions through which they had passed.
So terrible was the conflict and its implications that afterward, all records of it were purged from Imperial histories, and its remaining traces all but lost in the turbulent years that followed. Some heretic adepts point to the sudden weakening of Imperial power in those long forgotten days and the vast deserts of lifeless worlds on the eastern Fringe as proof of the Echoing Vault’s existence. Most (including many in the Holy Ordos) scorn this legend as either outright fabrication, misinterpretation, or a lie designed to cover some other, darker truth. However, in more recent years, some within the Calixian Tyrantine Cabal have drawn parallels with this long discredited legend and the phenomena known as Komus, the Tyrant Star, whilst others instead favor different explanation of the myth---a mangled misinterpretation of a Chaos incursion, a short lived warp rift or even some long forgotten Tyranid precursor hive. Some few who know of the story wonder if somewhere in the vastness of their silent other realm, removed from both euclidean realspace and the empyrean seas of the warp, the Harrowing yet wait patiently for their hour to return.
Source: Dark Heresy: The Radical's Handbook
I love how the story is sort of self-aware about the unreliability of information in the 40k setting and deliberately leaves things up to interpretation of whether something really lovecraftian emerged from a different dimension through an obscure artifact/structure or if it was "just" a misconstrued chaos invasion or tyranid splinter fleet. It's these very well crafted short lore nuggets, that to me make the 40k setting feel vast and utterly fascinating.
But wait, there's more! In the 8th edition Custodes codex we get this little lore nugget:
The Echovault
Led by the ambitious Chaos Lord Hadrexus, a sizeable contingent of Black Legionaries fall upon the world of Dakhorth. They sweep aside the planet's defending regiments and advance to secure the ancient xenos ruin known as the Echovault. Before they can lay claim to this mysterious structure, two of the warships known as the Moiraides appear in orbit. The Custodians of the Dread Host deploy in force, securing the mountain pass that leads to the Echovault with squads of Custodian Wardens who hold firm against wave after wave of attacks. Meanwhile, multiple Shield Companies strike at the flanks of the Traitor force, pulling their formation apart and dividing their strength. Finally, a decisive force of forty Allarus Terminators teleports into the very heart of the Black Legion lines, tearing their command structure apart and slaying Lord Hadrexus and his Chosen to the last. Though dozens of Custodians fall during the fighting, they smash the Black Legion invaders utterly and send their remnants fleeing back into the Warp. As for the Echovault, it is left undisturbed, and a permanent garrison of Custodian Wardens left to watch over it.
Source: Custodes Codex 8th Edition, S.32
Now, since I know that there are people on this sub who love to try to take apart everything I say, let me be clear: I am aware that the name of the vault slightly differs in the Custodes codex, but in my opinion, it is a clear reference to the lore in the Radical's Handbook. It kind of makes sense and is additionally flavourful in my opinion, that the name of that relic/structure slightly changed over centuries or milennia.
Now, if we agree for the purposes of this conversation that the excerpt from the Custodes codex is a reference to the Echoing Vault in the Radical's Handbook then it really speaks to the danger this relic/structure poses to the galaxy. Why? Because the excerpt makes some very interesting statments about the forces of the Custodes that were deployed to stop the vault from being opened again. It states that two of the Moiraides were sent to deal with the issue, now why is that significant?
The Dread Host represents a breathtaking concentration of military might. It numbers hundreds of Custodians, organised into multiple shield hosts and transported abroad a trio of pre-heresy warships known as the Moiraides. The nature of this army is simple, they are the deliverers of the Emperor's judgement, his anger and his punishment made manifest.
....sometimes one warship is sent, sometimes two; only a handful of times in the entire history of the Imperium have all three of the Moiraides loosed the passengers against a single foe...
Source: Custodes Codex 8th Edition, S. 25
Considering how rare the Custodes are in the grand scheme of things sending two of the warships of the Dread Host to keep the vault secure means the threat was deemed absolutely serious. With this we can estimate that the potential destruction that can be unleashed from the vault is so great, that it lead to one of the largest deployments of Custodes that we know of against a single foe since the heresy. Especially against a foe that was not on Terra itself.
In addition to that it speaks to the dangers of the vault that a permanent force of Wardens are left to guard it. Like 'em or hate 'em, but Custodes are valuable and very expensive assets to the imperium, and leaving even a few of them permanently on some rock somewhere in the Segmentum Obscurus is a testament to the fact that this was really, really serious.
And since this always comes up when things like this are discussed. Yes, the excerpt states that dozens of Custodes fell in battle when defending the vault against the Black Legion forces. People often get their knickers into a twist because they feel that Custodes get worfed to make a foe in the lore seem particularly powerful. And while there are instances in the lore where I agree with that assessment, I do not think it applies here.
Consider this: for two of the Moiraides to have been deployed to secure the vault, the Black Legion force would have to have been a massive threat. The excerpt makes no detailed statement as to how large the Black Legion host was in actual numbers, but since deploying two of the three warships of the Dread Host was deemed necessary, the threat level must have been huge considering how adept Custodes are at trouncing chaos marines in particular.....just think about how much you have to screw up that forty Custodes terminators deleport right up in your face to take out your leadership.
Also and this is something that is sort of a pet peeve of mine in these discussions: Custodes being the most individually skilled gene crafted warriors in the imperium (not counting the Primarchs) does not mean they can not get killed in war by being overwhelmed by superior numbers, outmaneuvered, getting hit by a lucky shot etc.
So anyway, I hope you liked these excerpts and the references to some really cool, old lore from the Dark Heresy books.