The PS4 is known for incredible single player story led games. I do miss the days of adventure gaming but I think Indie games have that covered now, you just have to go look for it.

Edit: I think it also requires a lot more capital to do multiplayer right, unlike single player where anybody from a hobby game dev all the way up to the big Sony studios can provide an equally satisfying experience.