As an old fart, I'm happy to see that Debian is still cool. All of this arch-manjaro-nix-os-awesome-bspwm-i3-xmonad-flatsnap whippersnapper stuff is over my head.
Debians make for very good servers, I've been using Debian servers since moving my desktop from Fedora (when it was still called Fedora Core) to Ubuntu. I don't regret it one bit. The community is excellent, and there is ample information available online without having to ask a new question.
My vote is Archlinux. Debian is sometimes a little too "optimisitic" when backporting security fixes and upgrading from oldstable to stable always comes with manual intervention.
Release-based distros tend to be deployed and left to fend on their own for years - when it is finally time to upgrade it is often a large manual migration process depending on the deployed software. A rolling release does not have those issues, you just keep upgrading continuously.
Archlinux performs excellent as a lightweight server distro. Kernel updates do not affect VM hardware the same they do your laptop, so no issues with that. Same for drivers. It just, works.
Bonus: it is extremely easy to build and maintain your own packages, so administration of many instances with customized software is very convenient.
It's quite a steep learning curve, but after some time (after you've configured your "dream-system") you don't want to go back/switch to any different distro.
Specifically servers IMHO are a great use-case for NixOS.
It's usually simpler to configure than a desktop distro, and less of the usual pain points of "dirty" software (like hardcoded dynamic libraries, that exist on most systems (ubuntu as reference) at that path).
I've much less fear maintaining my servers with NixOS because of its declarative functional reproducability and "transactional" upgrade system, than previously (where I've used Debian mostly).
If your solutions are work/job related and need to be distributed I think your current options are SUSE or Debian. If your solution is something only you maintain, you could check out NixOS.
I've been running Debian stable for years now on everything. My laptop runs it, my home server runs it headless with no GUI installed, my gaming desktop runs it and even my kids run it without issue. If we need a newer version of some desktop app I just get the Flatpak. It's pretty great and the good thing is that it's predictable. Once it's up and running I don't have to worry about things breaking because of an update.
I have been using Debian for about 20 years now. Server and desktop. But I recently migrated all my server stuff to FreeBSD and I don't think I will move back. Jails are great and provide me a convenient way to isolate my apps. On the desktop side I will stay with Debian.
If you need enterprise support I'd look for Ubuntu or maybe SUSE. If you can't tolerate RHEL closing their source, that is (some people won't be bothered).
If that's not needed, then Debian all the way! It's served me well for like 10 years in my home lab.
For my public-facing server, I use Debian Testing, since I haven't had any major issues with it's stability. Auto-upgrades usually work , although there were a few times I had to manually intervene on the latest name-change upgrade from Bookworm to Trixie. I usually don't even log-in except every few months.
At home, where it will only affect me, and possibly my family dealing with me, if the whole O. S. crashes and has to be rebuilt from backups, I use Arch.
Any issues with CentOS stream for your work? Could always switch to Fedora server too if you wanted to keep the same structures and such, but separate some from RedHat.
I don't understand what's happening at Red Hat. First they pull the codecs out of Fedora which is supposed to be a community distro so why are company lawyers involved?
Now basically closing their source code. I mean technically not violating the GPL cause you only have to have your source available to your customers.
I would definitely give openSUSE a try. such a solid distro. Debian is also great, popOS seems likeable, nixOS is very very solid, I've used Arch, Manjaro and opensuse myself. currently on arch. but I highly recommend openSUSE
Have to also add to the voices recommending Debian stable. I've used it now for ten straight years after I stopped distro-hopping for my servers and desktop, and I cannot imagine using another distro. It's incredibly stable, but the best part of Debian is the absolutely expansive repositories that even the Arch User Repository can't beat. Very rarely do I ever need to use Flatpak (ugh) for packages, or look to add in new external repositories.
On my Desktop, I switched to Manjaro (Arch-based) from Mint a few years ago. Works like a charm and I like the rolling release model.
On servers, Ubuntu, Debian or SUSE might be a good choice.
I'm also moving away from RHEL. I have 3 RHEL servers right now, a hypervisor host, a podman vm, and a Samba share vm. I really liked that you could specify regulatory compliance at install time. Makes it really easy for standing up compliant servers. Are there any distros that do something similar?
If you are willing to abandon Linux, I would suggest FreeBSD for general purpose servers.
It is a full operating system, which starts you off with a CLI, that is easy to configure. There is a full handbook that describes the full process, and it is on their website. FreeBSD is an operating system, rather than a distribution of cobbled together packages. Due to this, operating system binaries, and package binaries, are separated. This makes configuration on the OS level consistent.
A lot of Linux programs come from the BSD family. FreeBSD also has its own hypervisor, named Bhyve. FreeBSD has its own version of Docker as well, they are called jails. It might take some time to learn, but I promise it will be worth the time.
@bzImage For desktops/laptops my goto is https://ubuntu-mate.org/. For servers, I still use Rocky 9, a RHEL based distro, but I've been happy with Ubuntu servers as well. The ubiquity of Ubuntu just makes it easy to search for solutions to anything you encounter.
If you want easy way - Ubuntu. All packages exist, all developers support. But snap is pain.
If you need mainline packages - Arch. But be care with bugs. Use LTS kernel or you can broke filesystem on one day for example.
If you want forgot about dependencies - NixOS. But Nix not classic packet manager and you can feel pain on start.
In reality, a lot depends on the environment in which your code will work. If it's Java, then in principle it doesn't matter, but if it's C/C++, it's better to develop in an environment as close to production as possible.
I can throw in a vote for Debian stable as well. I've recently installed Debian 12 and I've been blown away by how great it's been compared to my recent Fedora 38 experience out of box.
I'm a long time Opensuse user but that is also somewhat RedHat based I think . Highly recommend it, though. Have been using it on a server since 2014 and just kept updating through all the opensuse versions since then without problems. Exceptionally stable.
Also use it on my work laptop and I'm also with that very satisfied regarding stability and usability.
This question is just going to draw a lot of "hey what's your favourite distro" responses.
But if you want something EL-like that isn't RHEL, consider the bastard child of Conectiva and Mandrake, long ejected from the RedHat family but still very similar -- PCLinuxOS. It has the superior signed packaging format, and it has much of the same workflow. Its packer compatibility suffers greatly from its mageia times - I think - so they're still a bit ghetto about anything at scale, but that's almost the only thing they don't have nailed-down. Their massive compatibility window delivers on everything AppStream claims but cannot.
For minimal stuff, consider AlpineLinux, which also is free of Systemd and still manages to run really well for reasons Lennart's fans simply can't understand.