I’ve had no problems running practically everything I want using fedora. I would reccomend mint, popOS or endeavourOS instead as fedora is far out man and might be too cutting edge with some updates. (meaning you may break something and have to use the inbuilt system of linux to boot to the last working version for a few days)

I cant use autodesk softwares but whatever maya is replaced by blender anyway in gaming industry(I was a professional 3d artist for games), theres myriad of cad software but I switched to freecad (I design parts for cars and 3d print stuff). Clip studio and photoshop was replaced by krita which is insane that it is free as it is the best painting software out there. Photoshop was replaced by gnome and illustrator by inkscape.

Only thing you might miss are some games that specifically banned all linux users but its not like they are the only games to exist. Even tarkov can be played using spt mod which gives you a better experience anyway.

TL;DR: There are better alternatives that fill the same functionality and there are only a few edge cases where there arent. As more people switch to linux that means more donations, more developers making the missing software and more people finding and reporting issues and oversights that need fixing. Its a snowball effect.