Nobody cares, the average person, if they watched this at all, can't tell first party from third, what's only on Playstation and what's coming to Xbox. They have Final Fantasy and Spiderman, that gets them through the year.
True
Then they have a different press conference next year with Factions and Camden and maybe Wolverine.
I think later this year they'll show TLOU Online and Death Stranding 2 gameplay, Stellar Blade & TLOU Online release dates and next year they'll announce Cory's new IP, Twisted Metal, Team Asobi's next game (maybe Horizon MP game too) and Ghost of Tsushima 2 plus will show Wolverine, Marathon & Concord gameplay + release dates (all for 2024 or maximum early 2025).
Don't hope for anything. What they showed is what they have. "Real good single player games" need many years of development.
They are supposed to have stuff in the works like at least Wolverine and the Insomniac MP game, Death Stranding 2, Stellar Blade, Rise of the Ronin, Convallaria, Cory's new IP, Bend's new IP, Housemarque's next new IP, Media Molecule's next game, Sucker Punch's next game (GoT 2?), London Studio's new IP, the next MLB, Ballistic Moon's new IP, multiple Firesprite games, Horizon 3 and Horizon MP game, TLOU Online and whatever single player game they have under development, the other Bungie new IP under development, Team Asobi's next game, GT7 future updates and GT8 and so on. At least. In addition to this, they have many 3rd party exclusives that didn't appear in the show such as FFVII Rebirth.
Do you really believe that all these projects never existed or got cancelled? Many of them still aren't ready to be shown, while others weren't shown yesterday because they already were shown months ago or may be planned to be shown in other show pretty likely soon.