This is why I never really care about SP...replay value.
As someone who spent 200+ hours in Horizon and has replayed many of Sony's great SP games, and who couldn't put 15 minutes into most MP games without getting bored, I'll just say this is entirely a matter of opinion. The amount of enjoyment you get out of a game is a matter of subjective preference.
In fact, one of the main reasons I'm considering buying an Xbox One is to replay their great SP games.