There's an ongoing debate tantrum about introducing Rust code to the kernel. Some people are pushing for it, some people have made it their life's purpose to make sure that doesn't happen, it has led to a wave of maintainers resigning, and Linus is sitting with his thumb up his arse when his leadership is needed.
I used to prefer Gnome for the longest time. It seemed to be lighter on resources and cleaner. I tried KDE again a few years ago and was blown away at how much better it has gotten. KDE has quickly become my go to. The ease of customization, theming, and the wealth of settings sold me on it.
I ought to go back and try Gnome again since it's been a few years. I'm sure they've gotten better too since I last used them.
As a relatively recent Windows refugee, I want to share a recent success that has made me feel fully confident in never needing Windows again and fully feeling the Linux superiority.
I got Cyberpunk with all my previous mods running.
Maybe not a big deal for most people, but this was one thing that had kept me holding onto dual boot on my main device. Conversations online also kept making modding on Linux seem so impenetrable.
Then I decided to spend an afternoon figuring out modding games in general on Linux, and yeah parts of it was tough for me to figure out, but now I'm confident that anything I used to do on PC, I can probably do better on Linux.
I am ready to take up arms alongside the Weaponized Assault Penguin squad.
For mods? Personally I just browser Nexus mods for what looks fun or interesting. Just getting command lines going is fun enough for a start. I always at least start a run giving myself a bunch of cash. But honestly, the vanilla game is plenty fun now and pretty well balanced compared to when it started. Still finding side content and weird stuff
For general modding I started with the Redmodding Wiki and then I got over complicated trying to use a mod manager, messing with Steam Tinker Launcher and Mod Organizer 2. In the end just did things manually following the redmodding wiki.
Games: nope. Same as someone above, I've got Cyberpunk on Linux
Office/Adobe... may be a fair point for some
Nvidia card: nope, works fine
HDR: did not even bother to learn what is. Can be a fair point
Fractional scaling - genuine question: who the hell ever needs this? I have gone from 1K resolution (standard laptop) to 2K to 2.5K to 34K with curved monitor and never ever ever did I think "hey, this big screen? I want everything bigger/smaller on it". What do people use fractional scaling for?
Your post smells of someone, who only uses their computer for fairly limited tasks.
Office/Adobe
There's so much software around serious work, creativity, and productivity, that doesn't exist for linux or is meh. CAD, audio, video, music production.
The main reasons I use macOS are GarageBand and apps for DJing. Anything audio still breaks far too often on linux or is otherwise a pain.