Fedora, it fucking slaps and worked right out of the box. I'm using it for work and play on my main rig! I dual boot for some very specific hardware things that are not normal, but other than that it's been seamless! When I booted into Windows 10 again, they auto installed copilot... Glad to be done with this crap.
For photo editing, Gimp is about the same as Photoshop from 10 years ago.
For digital painting, Krita is good. I'm not a digital painter so I can't say how good.
For vector and design stuff, Inkscape is better than Illustrator. It's really good. (Except every non-Linux build of it I've used has been weirdly unstable.)