I enjoyed the story missions, but I was unsurprised and disappointed that they are in recycled areas with almost nothing new. Sepktis strike backwards as a story mission?! Come on. And there's only three of them! They made it seem like they tried a little harder with the story this time, lol. But these are really short missions. They're not bad and you don't have to scan things... but they're nothing special.
I like the new weapons / armor I was lucky enough to get, but I could have gotten most of them without the DLC anyway.
Jury is out on the PVP maps but I hate Skywatch so far because it's massive. It's like the entire patrol area from Cosmodrome. I am glad to have more variety though.
Will eventually do the raid, but I was never one to run VOG every week so there's not a tremendous value there for me either. Always annoying to find a group although I should really just play with you guys. In fact I'm more disappointed that the cool stuff I wasn't lucky enough to get in VOG is now not worth getting. Would really like some confirmation if new VOG legendary drops have the higher attack.