I use Debian at home on my homeserver and a mix of Debian and Arch for my workstations. Most of my stuff is managed with Ansible to make rebuilding easier and most workloads in podman containers.
Personally I don't overthink the distro thing. I recently started using Arch and quite like it. I've noticed packages that are available in Debian but not Arch and vice-versa. Debian Stable is nice because it's just, well, stable.
Fedora has an annoying release cadence IMO. I have experienced desktop bugs in the early GA releases before which put me off. If I wanted instability I would sooner go with Arch (and I am yet to have many issues with Arch yet).
If I were to go with a BSD for a home server it would probably be OpenBSD or FreeBSD. OpenBSD has vmm and a bunch of tooling around it, and FreeBSD has bhyve and jails. I haven't taken the plunge because Linux works and it's what I know.
These days I hear about people using proxmox on their homeserver with LXC containers and/or VMs.