It can be depending on what you like. You have a flying drone to help you that isn’t in multiplayer because there you all have different abilities to cover each others’ weaknesses.
Personally I think single-player gets stale and lonely quick, it’s just a lot more fun panicking and overcoming challenges with friends.
But who will they find to play Norman Reedus?!