You MUST be aware that document editing, CAD, photo editing, video editing, and gaming suck on FOSS

Well, turns out it doesn't. LibreOffice is really nice to use and automatically works with my theme which is always nice. You also have OnlyOffice if you want something with a different UI , though, it is Russian owned and has weird licensing issues going on.

Photo editing is also really easy, there's lots of good stuff out there. Rawtherapee is great for processing photos from my camera, but Inkscape is AMAZING for vector work (what I usually deal with)

Video editing with Kdenlive is very smooth, I don't do too much if it but if you need additional functionality you can also use Davinci Resolve.

Games on Linux runs fine and dandy, Hades, Hollow Knight, Hearts of Iron IV, Minecraft (p.s. the cross-platform Prism Launcher is awesome for managing versions, shaders, and mods!), and Balatro (all of which I installed as Windows games) run really well (Proton/Wine is awesome!), and there's also a few neat native Linux games that are fun, quite basic, nothing graphically intensive, like 2048 and puzzles. Xonotic is an exception though, but it's pretty old now. STK is getting a new release soon and I'm excited for that!

As for emulation, Retroarch and all the cores run fine, no weird compatabilities here! I can run my favourite GC, PS2, GBA, DS, etc. super easily!