Multiplayer in this game has dead community and all, so it doesn't have anything to interest normal players outside of introduction of Solo Survival. They are divided into two categories: "survive with limited lives and time" and "beat boss/level with limited lives and time". And well, while limitation of lives make it more interesting than trying to run multiplayer survival with 1 player slot and achievements give motivation to beat them, they aren't too different from multiplayer. Just not infinite. Still got Multiplayer speed, can't select difficulty, can't select Tarot Cards.
And to be honest, solo survival doesn't fit to Painkiller. Even if it can be hard, it still boring. Takes too much time. I mean, the main game itself feels like solo survival, as you have to survive hordes of enemies in each closed arena. And now you have to do that, but either by being in same spot of map for 5-20 minutes or by killing much more enemies in each arena, making it quite a dragging experience for Single-Player experience.
I mean, no one likes Painkiller Redemption. Or Recurring Evil. And some maps feel like that. Well, especially seeing how both Redemption and Survival use multiplayer maps.
Oh, yea, and you get Tarot Card that makes you start with 666 ammo. DLC doesn't tell you about it.