There really is no excuse for one of the most valuable and profitable companies in the world to not properly test their flagship software.

Nope - eben Steam is only a small subset of all gamers. Most gamers are on smartphones. Others are on consoles and many others are playing outside of steam. And you have to count the steam survey correctly and count the “Laptop GPU” as integrated.

But IMHO the problem is another: There is currently no sweet spot for a cheap and capable GPU like the 1050Ti was back in the day. Some people will spend thousands of dollar for a GPU, but GPUs have been really expensive for a long time due to bitcoin, Covid and AI. You can see that in the steam survey - some of the most popular cards like the 1050TI or 1060 are ancient.

That puts game companies in a really bad position: They could release games with fancy graphics, but only a small subset of games can run them on their rig. And producing a multimillion dollar game for 2000€+ devices is not a good business proposal.