I only really have two pain points, one of which isn't the fault of linux, and the other that probably is.
First: Adobe shit. I depend on Adobe Lightroom. This is entirely on Adobe. I know about the alternatives, but apparently I suck and can't get good at them. I keep a Mac laptop around just to use this application. I tried screwing around with Wine and VMs to get it working, but it's pretty useless without GPU acceleration, and so far the only way to get that in a VM is to have a second dedicated GPU just for the VM. Plus, that still requires keeping a Windows installation around.
Second: Wake from sleep. Just doesn't work properly on my desktop PC running Fedora 43 with KDE. AMD CPU and GPU, etc. The computer does wake up but the display never does, and nothing short of a hard power cycle seems to make it recover. Works just fine on my Thinkpad which is running the same environment, also all AMD but with just whatever AMD integrated graphics came with the CPU in that case.
Having chatted with some other people experiencing the same thing with similar hardware setups and F43 with KDE it apparently doesn't manifest if using GNOME, just KDE. For now I just have the desktop set to turn off the display when idle but to not put the machine to sleep. I am a KDE enjoyer, GNOME does not float my boat.