I have to admit I've had a great time playing through The Curse Of Osiris multiple times with different characters.

Unless you've already bought this as part of a season pass, don't waste your money on Curse of Osiris until Bungie actually changes direction, and I'm not talking about executing their proposed changes which painfully miss the mark yet again. The base game of Destiny 2 is a great shooter for 50-60 hours of solid content on your first play through of a redemptive story. But there is no endgame to keep going beyond that and there isn't anything packaged into this DLC than enhances that initial experience. At this point, if you're desperate for a looter/shooter then either fire up Destiny 1 again, watch Anthem videos on YouTube and hope for a brighter Q4 2018, or else maybe go give the Division a chance. It had a dumpster fire launch but can be had on the cheap now and I hear it's become a very good game in its current state.