I think the little mentions and details is what makes the lore good in my opinion but I do understand what you mean. They kinda build stuff up in the lore and then they present an all powerful entity mentioned through the lore books during a boss fight where they become pushovers. This is where I think super secret boss fight should come into play. Using info from lore books or item descriptions to navigate to a certain room during a strike or a raid or something. Work for the chance to fight hardcore lore bosses or see them as Easter eggs. Fingers crossed that we get to see the giant fish under NPA on Titan up close!