Warframe is such a strange game to play. I maxed out my Excalibur, its ultimate ability, I've got Level 30 in like two swords and maybe 25 on a sidearm and the default auto rifle. I've been filling out the planet map slowly, I'm having some modicum of fun... but Destiny 1, at least 25 hours in when I first played, had me handling House of Wolves and very early Taken King content, maybe an Exotic from Xur if I was really lucky. With Warframe, so much crap is buried behind the star chart and the main objective quests have been overhauled like a thousand fucking times since the game launched in 2013. Moment to moment gameplay is fun... but I kinda don't have any real hook. At least D1 when I first started with Taken King had strikes, patrols, gunsmith bounties, faction rep bounties, pvp bounties, daily missions, and so on. It scratches a similar itch, it's arguably superior in multiple ways to D1 and especially the nightmare that D2 launched as and ultimately metamorphosed into. But it doesn't quite spark joy despite the fantastic gameplay.
Apparently 60% of players give up before the first two hours if the steam achievements are anything to go off. I ain't asking for P2W boost items, but like... some grimoire cards, quest tabs, lore notes, maybe a compendium or two would go a long way here.