There are a few no-brainers, yes. If you are into creating audiovisual content (photography, music, videos) you should end up with https://ubuntustudio.org it’s REALLY complete and runs out of the box. All the weird add-ons are already installed, you can’t go wrong with it. I used ubuntustudio from 2011 to 2019.
feel like getting into some scientific computing? There’s https://www.scientificlinux.org/ made to measure for and by Fermi labs and CERN, so it should be OK for your “self driving model car” school project, too
and the “classic” for everyone who want’s to test the safety of a system he is administrating is https://www.kali.org/ … I like the term “offensive security” ;o) but it’s really not a distro to toy with. Kali has no user, you are always root and … you pay for every stupid error.
I remember some “Christian Linux” but it sure was not of the catholic persuation. A single google search got me this: This Linux Distro Tries to Save You and Your Soul - a bit weird, but hey - giving computers with Linux away is the perfect definition of “doing God’s work” in my book ;o)
My very first Linux distribution - my first install from six CDs - was DeMuDi (debian multimedia distribution). I searched for it and … someone still pays for the server and domain https://www.demudi.org/ check the calendar top right … yes, I am THAT old.
This is actually an interesting question: does anybody know other specialized distributions catering to clearly defined users? Wasn’t there an Open Suse Medical distribution? Who can add more info and/or distros here?