I think the only two areas left where Linux is still lagging behind is 3D CAD software, and maybe some aspects of the adobe suite?
In all other areas I can think of, it's pretty damn good. For reference, the tasks and apps I use on Linux:
- Photo editing and art: Krita
- Video editing: Kdenlive or Davinci Resolve
- Documents and spreadsheets: LibreOffice
- Creative writing: Novelwriter
- Pixel art: Pixelorama
- Vector art: Inkscape
- Desktop publishing: Scribus
- Music creation DAW: Reaper
All of those apps are either open source or have no anti-consumer subscription features, and are what I would personally use even if I was stuck with Windows, so Linux had no real downsides for all of my specific needs.
I'm also fortunate that I had never built up any muscle memory in some proprietary app that doesn't work natively on Linux. Soneone deep in the Adobe suite may have a harder time transitioning.