It's today. I encourage you to actually try it rather than repeat an old trope.
Use Mint or Fedora for distribution. Use Cinnamon or KDE for GUI. Everything pretty much just works, man.
Games work -- Steam, Battle.net, Lutris, and others I am sure. Sleep works -- just as well as it does on Windows anyway. Network works -- better and easier than Windows IMO. Updates work and waaaaay better than Windows. Backups work. LibreOffice works. Browsers work. Tools work. USB thumb drives work. External USB enclosures work. CD/DVD drives work. I haven't tried blu-ray but I imagine that works too.
The only things that don't work are the things that lock you in to Microsoft. Those are vanishingly small numbers of things outside of business, and in business it's mostly because of inertia.
This is not a boolean. Games work, just with way less framerates.
My family is Ubuntu-only since 10 years ago, and I have 2 daughters that only know Unity as the graphical UI for a desktop PC (well, the big one is unfortunately starting to see Windows at school).
Not by a long shot. Windows-only enterprise software (QuickBooks, SolidWorks, etc.) is the last bastion, and that bastion is going to hold for a long time.
Windows of course doesn't go anywhere and will have a significant market share for decades to come. But Linux has come a long way. I'm not even interested in it, and use it because it's the simplest "just works" OS without having to actively defend against various dark patterns and anti-features.
Unless they all band together, their capital is not enough to sway Microsoft at all.
But yeah, SolidWorks is notoriously flaky. It doesn't even work OK in a Windows VM. Or on any modern Laptop with discrete GPU.
QuickBooks Online is missing so many features of QuickBooks Enterprise that they probably shouldn't even share the same name. Many places I've consulted for are locked-in to Enterprise.
They also conveniently void your support if you use a VM, despite VMs working fine.
The experience was so good that a few months ago I tried Bazzite (a "flavor" of Fedora Universal Blue aimed at running Steam games easily) at home as a test and despite my nVidia card (which it really didn't support well until recently) it's been smooth sailing. If it matures a bit more, I may ditch Windows completely... and that was already the last Windows machine at home.
But in 2024 you clearly are still the true expert and arbiter of what constitutes a working desktop OS. I mean I only use Linux on a desktop and a laptop every single day, so I probably don't really get it.
But truly, Linux gives me significantly less "broken in weird ways" issues, as you say, in daily use than Windows 10 does on the same hardware. Both sometimes do stupid things, and both sometimes require stupid incantations when things go wrong (please don't pretend windows doesn't, because it absolutely does).