I've done both. Destiny 2 was fun until it had very little to offer, which was quite quickly.
I had been playing warframe just before Destiny and was burned out at mr23. I've recently gone back, got to 24, and loving the end game content - collecting all the weapons to get to 25, leveling focus, killing eidolons, running sorties, there's a lot to do.
Funnily all the things you do are done across reasonably similar maps, but the process never feels tiring. I'd say that's down to a mix of the randomly generated tilesets, and the fact that the combat and movement is just so fun. Getting better weapons / mods in this game means something unlike in Destiny 2, and the difference in taking down enemies can be immense based on your build. The sheer variety of warframe mixes in your team further adds to the uniqueness of any given round.
Yes the story is lacking to a degree. It's very much an afterthought but has been worked on a lot and it's getting there. There's the new game intro setting you up vaguely, after which you just gotta keep banging out the mission nodes to get to the next planet. Sounds dull on paper but it really isn't. Then at some point later in the game, a couple of story arcs will kick in and blow your mind. Save yourself spoilers and enjoy the ride.