There is no "Maybe" or "It Depends" option, so I'm saying "No," but I'll explain why.

The gun-play and mobility in Destiny 2 are top-notch; it is easily one of the most fun shooters I've ever played, and the co-op experience makes it even better. I'm not a competitive gamer, so I don't play Crucible unless it's for bounties, but I understand people who like PvP really get into it, and I can see why. (They even have Iron Banner content for hardcore, eSports-level players. Personally, I love Gambit, which is PvPvE.) The art style is amazing and creative, and the music is excellent at creating the mood it sets out to meet. It's a really pretty game with a lot of aesthetic variety.

I would recommend buying Destiny 2 on these merits alone; alas, I cannot. The bulk of the game's content is sealed behind a prohibitively expensive paywall. Every expansion is essentially a full-price game, and while the base game includes plenty of fun things to keep you busy — the standard Red War story, bounties (think, micro-missions), public events, patrols, vanguards, raids, one dungeon, Dares of Eternity, the first mission of each expansion — once you've done all that and are looking for the next level of gear and enjoyment, you have to spend an entire paycheck to unlock it. This includes seasonal content and anniversary editions, which you will buy repeatedly to stay above board. The base game is free; nothing else is.

If you're rich and have so much disposable income you literally roll joints with hundred-dollar bills, then it's almost certainly worth your time and investment. The rest of us need to be satisfied with the base content. . . which can give you plenty of enjoyment, but eventually you'll be yearning for more. (I also have it on good merit that the only expansion you really need is Witch Queen, as it's indisputably the best, and that the latest, Lightfall, is absolute trash and only worth getting for the bonus sub-class, so. . . you can save a lot of money buying just those two.)

TLDR: It's fun as hell, but it'll cost you a fortune.