Debian is awesome, just to join in on the high praise. My main server is currently running Debian 13. As others have said so hard to break. I also have a small Lenovo IdeaPad Duet3i (only 4GB RAM and super-lightweight CPU) which also runs Debian 13. And it's perfect OS for this sort of scenario too. I think the only quirk I've seen on Debian was recently when I logged in via Cockpit on my older Debian 12 install and 4 services including PCP (metrics/logging) had all stopped running and wouldn't restart. I think an update had maybe stripped some dependencies, but it was so easy to fix just reinstalling Cockpit/Cockpit-PCP.
I could easily run Debian as a daily. I think the other strength is that often when organisations say they have a Linux version of their software it means a .deb version. Take Obsidian for example, no rpm, or pkg, they offer a .deb, Appimage, Snap and community Flatpak, or AUR. That said if I'm using a machine for gaming I will default to something like CachyOS, Arch or Fedora. I do think those are better for that use case. Not that you can't on Debian, but just personal preference.
I am going to re-build my two small mini-PCs as home servers soon to run ssh, nfs, Docker, Pi-Hole etc.. And it will once again be Debian following a little bit of exploration of the NAS/server OS scene. It's just too dependable and easy to manage.