It's good, without having 100% of the content out (raid this week at reset) it is already my favorite expansion for Destiny 2. Its real close to the Taken King across both games for me, if the raid delivers Itll be #1 for me.
The story started pretty one note, and really it sort of is. It ends with a little bit of a cliche twist, and something that didn't particularly make me feel good about what happened... not in a "this is bad" sense but it was very morally grey.
The Blind Well is a super fun public sector activity, and the public events in the Tangled Shore are fun. The Dreaming City on the other hand is too hard... it's a patrol space, why does it need to be ball crushingly difficult? I'm constantly getting killed just driving my sparrow to different locations.