So whose ResetERA account are you the spawn of?
Well it's one thing to just look at an individual IP and in that regard, yeah, Elden Ring is the only one with the selling power of COD. But we also don't know if that is a sustainable selling power i.e will Elden Ring 2 have a similar performance or will it drop? We don't know yet and won't know for several years. But that IP still has to "prove" itself in terms of having big selling power beyond a single entry.
Realistically, while you're right that Japan itself is a bit of a lost cause for non-mobile game software (unless you're Nintendo), the truth is Capcom, Square-Enix etc. have games that resonate REALLY strongly with Western audiences and that's a bit reason why I think Sony should secure those publishers so should the opportunity arise. It doesn't matter if Street Fighter 6 does like 250K lifetime in Japan when it could do 8+ million lifetime outside of Japan, but the point is it comes from Capcom, a Japanese 3P publisher.
And IMO, when you cumulatively look at a lot of the IP some of these Japanese publishers have, and look at not just the sales but also cultural cache they have in gaming and even in the mainstream, it doesn't matter if a single one individually can't go up against COD; just a few of them combined can do so on one or several metrics, and for a lot of people, almost any one of those IP are more exciting for them than COD. Again just sticking with Capcom as an example, you have Resident Evil, Street Fighter, Devil May Cry, Monster Hunter, Ghouls 'n Ghosts and then when you dig further back into the vault, Onimusha, Rival Schools, Breath of Fire, 1945 etc.
IIRC, each of the RE remakes have done at least 8 million copies average, and the new RE games have done like 10 million if not more in sales. That's great sales revenue there, not to mention these are all known for being high-quality games, and they've building on a nostalgia cache that's been forming since 1996. That's market value in both tangible and non-tangible forms. There are other Japanese publishers with similar qualities IMO, like Square-Enix, Sega, Bandai-Namco etc. Also IMO, there's added value in that many of them have been with PlayStation since the beginning and some are very much responsible for a lot of the build in early brand value and fandom for the PlayStation brand as a whole.
So those are my reasons for why I think, if it comes to Sony needing to make some acquisitions, they need to target at least a couple of prominent Japanese 3P publishers, and IMO the two best fits would be Capcom and Square-Enix, if they're willing to sell. I don't personally think many Western publishers are worth buying for them, not to mention the few who would be, like Take-Two, just would command too much a price and Sony would be better off buying shares into those companies and investing into them as much as possible, kind of like what they've been doing with Epic.
EA doesn't even have the FIFA license anymore so that really cuts into their value, plus they're kind of in Take-Two territory where it'd command a bit too much plus Sony could do just as well simply buying shares into them. I doubt Epic are going to get acquired by anyone, certainly not another platform holder, and in any case Sony have a good amount of shares in them and can buy more into the future. Epic are also way too involved with their UE5 push into all areas of entertainment to ever consider locking down games like Fortnite exclusively to any one platform, or play favorites in terms of content for one platform, even if they were acquired. They clearly don't want to fracture their fanbase with that type of stuff.
I know some people say Sony could go after Ubisoft and/or CDPR, but I think both of those would be redundant, plus Ubisoft have a TON of staff and in the case of an M&A, lots of redundancy to cut. CDPR are very talented but Cyberpunk didn't perform the way it should've and the only other game they have is The Witcher. They also seem overvalued in the market, so there's also that.