Look, I have a love-hate relationship with this game.
Single player on the one hand is a dumb B-movie fun, on the other hand it usually is a irritating slog due to horrible partner AI.
But it is also one of the best co-op games ever made. So much fun (ofc if you accept that it is not a horror game).