I never played the first Destiny, but Destiny 2 was something I poured about 500 hours into and enjoyed it a lot!
It's just... it really started to lose me when Beyond Light came out. I tried to stay with it but it just feels like it's been going downhill more and more as time goes on. The idea that so much is removed from what the game used to be to the point where you can't fully experience the story of the game you're playing first-hand just kinda hurts, and I wasn't even too invested in the first place.
I played Witch Queen and while I thought the story content was alright, I don't think the game itself is solid enough for me to want to continue playing, and I dropped off after I finished it.
I haven't been following the news too directly, but just knowing that they're pushing more full-price expansions while removing content and laying off their workers, I personally wouldn't dream of ever going back. I'm sad to see it go.