I don't think it's fair to call Cyberpunk 2077 a colossal flop. It had an awful release, but the company stood behind it and fixed everything that needed fixing. Five years later it is now an acclaimed game that sold 35 million copies.
You have to give kudos to CD PROJEKT for not just abandoning the game after a bad launch (which is what every other major studio would have done in its place) but patiently fixing problems and constantly adding content over 5 years to get to the state it is in today. And the game has no online requirement, no multiplayer, no microtransactions. Just one paid expansion which added a ton of new content. Rare to see this behavior in the industry today.
Afaik CDPR doesn't make many games. If one flops, that might be the end of them. I don't see abandoning a game as a valid option for them from a financial perspective. Makes much more sense to fix the issues and sell more.
Kinda how you trust paradox strategy titles to get several years of updates and expansions.
CDPR just was lucky enough to make enough money of failed release to fix it. Most companies get no chance to do it.
And the Switch 2 port likely cost considerable engineering effort and underperformed as well.
Maybe I'm not contributing meaningfully to the dialogue, but talking about total sales across a 5 year lifespan means you're necessarily including all those packrat users who picked it up on deep discount and haven't even booted it up once (or, like me, played two hours and in that initial window wasn't especially grabbed by the story, characters, or progression systems that the game was wanting me to engage with). It's different when something really pops off on release and sells all those copies in the first few months.