Interesting reading this thread as last year I did an evaluation of Linux by wiping my older NVMe drive and installing Fedora 36 alongside Windows. I would love to switch to Linux full-time on my main PC but unfortunately after a week or so had to switch back to Windows 11. I think some of my experience is the same as the OPs but I did have other annoyances. I also have used Linux on and off for over a decade so different DEs, package managers and terminal aren't new to me. I've recently built an Ubuntu 22.04 server and use Fedora 37 on a very cheap Lenovo PC/tablet (n4010/4GB RAM so Windows 10/11 ran badly).
If I only used my PC for Steam, browsing and light use I think I could switch to Linux in a heartbeat. Although I tried only a few Steam games, but Golf it! didn't run nearly as well as Windows even though it has a Platinum rating on ProtonDB. For me the issues are on Linux gaming are more pronounced away from Steam. My two daughters play Roblox and this is a pain getting to work with Linux.
Other than gaming we have a family licence for Microsoft 365 and therefore using this when not on Windows or Mac OS is a pain too. I also have a few devices with no Linux Driver or software support (Creative SoundblasterX G6) which will work with Linux but you miss out on being able to adjust settings. Also the lack of DRM support for Disney+ is annoying I sometimes use my PC for streaming and Windows is much better for this. There were a few other minor annoyances but I do think I could work through those.
But my recent experience of Linux (I've also tested Ubuntu since it switched to Gnome desktop) has been fun and it's definitely better than my last experience with Linux desktop (a long time ago). The improvements are clear. I want to keep an eye on it and hope that one day I can switch over. But even so it has come at a time I'm trying to 'de-google' and move away from proprietary software and I have found some great free (sometimes open-source) software; OpenRGB; confusing but means not having to run iCue!, BCUnistaller - feels like a near essential program for Windows, Obsidian, Hugo, Visual Studio Code, KeePassXC, Bitwarden amongst others. So its been a valuable experience. The beauty of these programs is that they are all cross-platform.