I think iforgotpassword gave a good reply to this, but I wanted to add a bit.
I agree it's not for everyone day-to-day, since I feel like inevitably you have to dive into the CLI to fix things with trying to get more obscure programs working.
As for desktop UI, IMO the tradeoff is that Linux DEs have no added cruft. I'd take that over Windows which to me seems filled with bloatware from MS before even the hardware manufacturer gets their hands on it. I've tried many DEs in my time with Linux, and I think GNOME in the last year or two is one of the best as a good mix of good visuals and highly customisable. KDE was closer to Windows but I've just never had luck with it being stable on various machines (seems to be surviving on my Steam Deck though).
Consumer device support is better I agree, though again IMO/IME that's more for certain niche hardware pieces or anything that has its own control app. Bluetooth is also something that I've still struggled with, especially when it comes to headsets.
Old games I can't agree with you on, but maybe that depends on your definition of old. I've had about the same experience getting old games (say from 2000 onwards) working, either with emulation or Wine supporting old software fairly seamlessly. And things have improved too. For example when I started using Linux around 2017, I recall Wine basically couldn't run The Sims 2 in a stable manner. Over the years since however, Lutris, Crossplay and Proton have taken the mantle and made games from that era work very nicely.