I don’t have a link to a comprehensive list but my personal suggestions are:

* GIMP for photo editing

* Krita for freehand drawing and for CMYK support

* Inkscape for vector images

* Scribus for desktop publishing (booklets, flyers etc)

* Blender for 3D graphics (modelling/rigging/animation) [1]

* Blender for 2D animation [1]

* Blender for video editing [1]

* Blender for compositing [1]

[1] Basically Blender is expanding in fields that are outside of 3D graphics and I believe that over time it became the best alternative in those fields.

I did some video editing in Blender a few years ago. I was surprised how solid and featured it was compared to other actual video editing suits on linux at the time.

I did a zine almost 15 years ago w/ Scribus and even back then it was an excellent piece of software.

Here's a decent list centered around photography:

https://pixls.us/software/

there was a website that was tracking that stuff. Not sure how often its updated, but:

https://alternativeto.net

So punching in illustrator:

https://alternativeto.net/software/adobe-illustrator/

Synfig for 2D vector animation:

https://www.synfig.org/