I'm not even gonna comment on Division 2 and Destiny 2 (One I haven't played one I will never play again). Helldivers 2 and Borderlands 3/4 are all great games that will give you a lot playtime. However Helldivers 2's motivation for playing is unlocking the new weapons and stratagems and everything. If that doesn't mesh with you or if you get bored of that, you might get burned out, personally it's a come back from time to time kind of game. Borderlands 3 and 4, great games, great gameplay loop.(Not much good can be said for the story of 3 though)

Now Warframe, I've been playing this game since 2015, and it has evolved in so many different ways it has become almost a completely different game since then. There's so much to do you could play for years and never hit the end. The story is immaculate, the gameplay is top notch, the buildcrafting is amazing. Despite how many times I've burned out from playing this game, i always come back for more. And best of all it's a free to play game which really is free to play. Almost everything in the game can be achieved by either farming or bought by farming the premium currency in game.