You really enjoy interpreting things out of context. I haven't quite figured out why, I didn't say that those games had less game play - but they aren't as gameplay focused. Games that are not narrative driven have very specific gameplay loops that lead to both mastery and longevity in terms of replay ability in a title. What do you mean you don't know what narrative driven means? It means the game is driven by the story and not the gameplay itself. How fun would any of these games be without their story attached to them, if there was no emotion ambiance to it? Do you want to make the case that UC, TLOU, Mass Effect and Bioshock players can clock more hours than Diablo, Destiny, Starcraft, Halo, Call of Duty, Tetris, and street fighter players can? I'd think you lose. Games without story are games first, never trying to tell a story, and those games have deep gameplay hooks which leads insane hours of enjoyment much after their stories/campaigns are completed.
I think you're confusing your own personal gameplay preferences for objective fact.
I clocked just as much time in UC2 MP, TLOU MP and ME2 COOP than I did in Destiny, and definintely more than COD (hate COD MP). Still doesn't mean or prove anything.
What you're trying so hard to classify as "gameplay focus" here and "narrative focus" here, doesn't exist in reality except in only the most miniscule of cases (e.g. The Order). All the game you classify as "gameplay focussed" that you mentioned merely have shit story and narrative and next to no characterisation. So it's obvious that the only thing left to leave a lasting impression on the player is the gameplay loop, but that's only because that is literally all there is to those games. Sure the gameplay is great, and has depth, but no more so than the other games mentioned.
Your mentioned "narrative focussed" games actually have good gameplay AND great narratives to go along with it. That's objectively a popular opinion that the reviews for those games reflect. The only difference is that these games ALSO have good stories to go along with the gameplay and so naturally those stories will leave a lasting impact and can often dominate the subject of discussion around those games. Gamers are humans, and so an emotional connection to a game's story or characters can be more powerful and leave a more lasting impact than the simple fun of a narrative-less gameplay loop.
The only games, outside of titles like the Order that clearly don't get the storytelling-gameplay balance right, that I would legitimately call "narrative focussed" are games like Heavy Rain, visual novels and Point & Click Adventures, of which I've always classified HR as a modern equivalent.
There's no more "narrative focus" in Sony's biggest games as any of the other major third party games. The only exception being MS, as since the original Halo, their games tend to end up with pretty shitty narratives. So maybe your perception comes from you having more a preference for MS exclusives, rather than anything else.
On the flip side, there's absolutely no reason to artificially constrain your selection to Sony's biggest AAA games (and even then there are exceptions, e.g. Gran Turismo, Motor Storm, WarHawk etc). Sony publishes lots of different games including ones with big presentation and narrative as well as gameplay, along with other pure gameplay-type games. So I would still strongly contend that Sony has lost it's moxie (whatever that is) because it's only making narrative-focussed games.