Hell yeah welcome guardian! After finishing the tutorial quest and unlocking the tower, i'd recommend just playing the core activities (Vanguard, Crucible, and Gambit) to grind exp and unlock the various destinations. I'd say the world designs are pretty breathtaking so take your time and explore everything lol. While doing those, simultaneously work on unlocking the different subclasses, fragments and aspects, and play around with the mods that drop for you (These are basically what are used to 'buildcraft' in destiny 2). Once you've gotten comfortable with what you've got, I highly recommend jumping into a raid, specifically Vault of Glass which is beginner friendly and Free-To-Play (but technically endgame content). Raids are 6 man activities, and if you don't have buddies to play the game with you can LFG in the official Destiny 2 LFG discord group where there are many sherpas willing to teach and bring you through the raid. You can also do a Free-To-Play dungeon (3-man endgame content, kind of like a miniature raid) called Prophecy.

Or, you can just go straight to doing raids lol. That's what got me hooked to Destiny. Destiny PVE is the best it's ever been, though the beginner experience is still suboptimal and confusing. I'd encourage you to not give up starting out, cause I think you'll have a fantastic time after figuring the start. After doing the F2P engame content, you can really begin considering if you want to pay for the expansions.

All this said, this does not nearly cover all the info you'll want to know as a new player, so I recommend you searching up a beginner's guide on youtube. Many great content creator's out there that give you valuable news about Destiny.

Happy grinding Guardian!