At this point outside of the outlier franchise games, I think SP games need to temper their launch expectations. People buy into the MP hype games like Destiny, Division, Battlefield, Overwatch, etc but for SP story games, the audience has definitely shrunk a lot from the hey days.
Still, with great word of mouth I think SP games can do amazingly well - I'd guess Doom has done quite well, even though the buzz was TERRIBLE at launch due to bungled marketing and a bad MP-only beta but the word of mouth has been super positive since launch. By contrast Mirrors Edge 2 has done poorly because few who actually played the game were that enthusiastic about it, just kinda a "meh... its all right".
So far the buzz around DX seems to be pretty good I'd say, I'm about 50% in and absolutely loving it and haven't seen a lot of people hate the game. The biggest vibe is that its more of HR, so if you liked that game you'll like this, if you didn't like HR you won't like this.