Yes, they said there will be single player DLC's as well. As for the co-op, it is fun and addictive if your playing with friends. I'm not too sure how it would be playing with randoms with no mic's since it is a bit reptative but it's definitely not bad. You should definitely give it a go.
Coming Soon: The Last Of Us and Beyond: Two Souls.