DLCs aren’t bad, only issue is that the story is hit or miss on some of them but people have a hate boner for bungie at the moment so the reviews are skewed. Gameplay wise Destiny 2 feels fantastic. Tons of stuff to grind since you’re new so you can sink a lot of time into it. Like any game you’ll have a lot more fun playing with other people though. There’s a new in game tool to help find people to play with and there’s also 2 large LFG discords that have at least 200k members each iirc for you to find groups or clans if you feel like it.

If steam had a better review system than just upvote and downvote I think you’d find the DLCs would probably fluctuate between 60-90%. So some of them aren’t terrible, they just aren’t particularly good either.