I use Debian on my servers, Arch on my laptop and desktop. Different tools for different jobs. I tried Debian on my laptop a few years ago but it wasn't a good fit for me - my hardware was too new for the stable kernel, and the Wayland/wlroots stuff was too far behind. As a server though, especially since I'm mostly running Podman containers, stable and slow-updating is great! I use unattended-upgrades and haven't had a problem yet.
I haven't spent much time with Fedora but I'd probably like it as a desktop OS - fairly fast updates, and sticks pretty close to upstream without a ton of custom theming for example. I would miss the AUR, but Flatpak covers a lot of what I need, and Distrobox could handle anything else.
My first VPS was for a Minecraft server so I named it cobblestone. I've kept using Minecraft related names for all my machines since then, and I try to pick ones that are at least vaguely related to the function or appearance of the machine. For example my cluster has brute for the master and piglin01-piglin04 for the workers, but those are the only ones I've numbered.
The exception is my two Klipper RPi's, one is octopi since that's what it originally ran, and the other is named after the model of the printer. For some reason I never named my printers.
I probably wouldn't use a naming scheme like this for production servers though - I'd either go with functional hostnames or something like the periodic table which you can pick from arbitrarily. My home servers and clients aren't cattle though, so I like having a little personality to the names there.