No the main campaign doesn't have coop, but the snapmap editor lets you create coop scenerios and maps. so if coop is something you really want in doom, you might wanna get into that or hope someone makes a pretty good coop map/mission
Since I pretty much was brought up on Doom and all the other awesome shooter games back then. This version of Doom keeps the fun, heart pounding adrenaline action packed fighting like the other Doom games have brought. Yes most of the video's out there are MP as ID/Beth didn't allow the reviewers to review the game with the excuse of the severs will not be up as both SP n MP need the servers.... Which is rather meh in my view.
But anyhow, I have been playing it on an off since it came out and it is damn worth it. Last time I played was in the early hours of this morning UK time about 00:30 in total I am 5 hours in on the SP campaign. Link I do have some screen shots of the SP campaign Link Trying to upload more but steams cloud system is being a . Anyhow you can see them via that link.
So the main answer to your question is. YES! It is worth it. Get the game jump right in and get killing and fuel that thirst for violence blood gory etc. Or wait is that just me.....