Warframe's story and lore is actually kinda fantastic, and the few spread out main story questlines are really, really good. Having played the game for years before Second Dream was released, I honestly got chills during the conclusion. No lie, this was one of the greatest moments I've ever experienced in a video game. The the way it's revealed, not to mention the stellar music, certainly helped, but I think it was mostly the fact that I had already invested so much time at this point and the reveal came seemingly out of nowhere, yet it made perfect sense and recontextualized everything that happened before. EDIT: Just remembered Shill Up did a pretty good, spoiler free video about The Second Dream:VIDEO