Honestly, all desktops suck these days. I find GNOME quite usable if you don't approach it as "fake Windows" or "fake macOS", while Windows 11 feels more like an incomplete KDE fork that tries to be Windows 10.
The problems the LTT videos are pointing out are problems that office workers don't need to deal with. They don't need to deal with package management, drivers or games. They need a browser, a home directory and an office suite. The LTT videos struggle with the obvious problems, most of which come down to very specific use cases (say, video streaming) and compatibility stuff (getting things developed for Windows, mostly games, to work). Also note that while Linus has been having tons of issues, his counterpart Luke has mostly been encountering minor annoyances.
I think the Linux desktop is great for a) advanced users and b) beginners that only do basic home and office work. The pain comes when you need to do moderately advanced stuff like automations, system configurations and obscure tools that few other people are using, or that aren't designed to run on that platform. In those circumstances, the community will direct you to the command line more often than not, and those users don't have the experience (or even the need, normally) to use it.
In a recent podcast the LTT folks said they were considering doing an episode approaching Windows from the same standpoint as Linux. Getting some basic stuff working on Windows (or macOS, for that matter) can be as much of a pain as getting it done on Linux, but we've been teaching kids how to use those systems for decades now.