Returning player question

Are the campaigns worth doing?

A few friends and I just got back into Destiny 2 and we got the DLCs, were interested in playing the campaigns in order regardless of rewards just to see the story we missed on, but just to be aware are the campaigns rewarding to complete for your characters?

While I’m asking, what are some of your guys favorite dungeons, raids for us to get started on.