You can look up the compiled data on PS4 in the long run having titles like Monster Hunter or Dragon Quest did not help it rise above it's predecessor, it provided a short term spike, but not a long term rise in consistent purchasing. PS3 lacked both Monster Hunter and Dragon Quest and still sold more than the PS4. And as far as the PS3 goes that was a system that was for the longest time primarily supported by Sony's western developers. Even games like Demon's Souls was played more in the west than in Japan. Japan Studio's own games had more larger titles on the PS4 than the ps3 and none of them did well in Japan. The place where you had more long term purchasing was always outside of Japan.
View attachment 3898509
The PS4 had games like The Last Guardian, both Gravity Rush games, and Knack 1 and 2. This was their entire Japan Studio output when it came to internally developed titles where they were not just a support studio. Titles like Bloodborne didn't even do well inside of Japan because the whole souls series popularity was always western focused.
Squaring it with PC gaming is an entirely different beast because PC and consoles are both different demographics as far as player base goes. Look at the games that the PC player base plays long term and then look at what console players play long term. The entire reason why Sony is doing PC ports is because PC gamers are looking for Multiplayer focused games which is why they're offering freemium games. How many of those Steam Japan users are playing things like Apex Legends? Japan isn't playing things like Elden Ring in any vast numbers as compared to other countries, they're not really buying single player games on PC.
The most popular game being played in Japan on playstation has been Genshin Impact. And in response to this Sony is making multiple freemium games with a similar system to Genshin's console/pc/mobile approach. So their future multiplayer games can be pretty much be played on common devices and generate income through microtransactions through their online store which is tied to their own console. These freemium games are the one area where every platform intersects because they all have some sizable chunk of players who want social games with a low cost of entry. But the majority of the player base who plays genshin probably isn't going to be a routine audience for things like Final Fantasy, Yakuza, or Souls games for example.
In terms of Sony's own first party games performing you just had God of War Ragnarok arguably become possibly the most successful first party launch of a game in Sony's history. Japan only purchased around 30,000 copies while other areas bought the game by the millions. Sony's other previous first party attempts outside of maybe GT never had sales reach that high in a singular week. You can even look farther back on the PS1 where Legend of Dragoon bombed hard in Japan and was needing it's western sales to recoup it's development costs and that game was a traditional turn based RPG. Even back then Japan was not really buying Sony's first party offerings in any large quantities. Globally sony is reaching heights it's previous output didn't reach for the last two to three console generations. It has much more secure and stable IPs now it can draw from for future titles than it has at any other point in it's history.
Usually in the past Sony relied on third party support and did not have very strong first party titles. Titles like Killzone never rose above mediocrity for example. But now their first party games are driving sales towards their systems on a very consistent basis.