Kojima has a history of overspending by trying to make grandiose but weird games. And while they performed well, MGS4 sold less then The Last of Us or other big hits. I think that Kojima's games are games that people talk about more than they play. Probably MGS5 is the only one that actually "plays good".
But how many of those games are console shifters? Hell back in the day I finally caved and bought a PS3 because of MGS4. Alright it may only shift say, 60% of the units, but if more of those units included a console purchase too then the onward value is huge.
Back then gaming wasn't as big as it is today. It does make sense to have TLOU outsold MGS4, they have 5 years gap, it is more than a decade later for both games now. I think we need to talk about percentage impacts rather than absolute numbers.