Stable/unchanging (zero maintenance for several years, no new bugs appearing out of nowhere), as minimal or bloated as you want it to be (made my own custom live/installer ISO which means I can start fresh with my environment already set up in a matter of minutes), huge number of pre-packaged software, good documentation, identical base distribution across my servers and desktops, mostly sane defaults, community-backed (no or few corporate interests driving the project to shit... look what it did to Ubuntu/CentOS...).

Other Debian-based distributions don't bring anything of value to the table for me, I'd rather use OG Debian.

I use Debian as a desktop both for work and personal use because I am a boring person that doesn't need any surprises. I have been using it since woody after moving from Mandrake Linux

I used Debian on my desktop and laptop for many years, eventually I felt like I was spending too much time thinkering. I switched to Ubuntu 20.04 LTS and everything works great. But the snap crap is getting in to my nerves so I'll probably switch back to Debian next time.

What makes Debian unfit for Desktop use? Nothing. Debian is as good a Desktop OS as Mint, Ubuntu, Zorin and any other distro out there. It isn't just for tinkerers. Perhaps it doesn't have the amount of new user friendly features but I would rather use an OS that pushes me to learn than pushes me to be complacent and also pushes me to seek the 1-click options rather than spending 5 minutes to set something properly. Debian might not be everyone's cup of tea... but for those who it is their cup of tea Debian will never disappoint.

I don't see Debian as a "server only" distro.

It is good at being a headless SSH-only infrastructure server, but it's also got a huge package set and many well-supported desktop environments, so it's a good desktop distro as well.

Ubuntu-based stuff is getting increasingly full of snap and ESM advertising and other rubbish I don't want.

Sure Debian might end up with older packages later in the release cycle, but it's not much different to using Ubuntu LTS as desktop, and anyway this is largely solved these days by desktop container tech (Flatpak, Podman Toolbox, distrobox, etc).

These (Mint, Zorin, etc) and Debian are basically the same. You can use either of them and have mostly the same experience once you finish setting up your system. Exception here goes for Ubuntu that forces Snap. I personally go with a minimal installation of Debian and add what I need along the way. If you don't want to set things up thoroughly, you should use a distro you think has the most functionality out of the box.

I typically install my own window manager, so Debian tends to to be perfectly fine for a base install for me.

Stability

And neither of this distros are good with stability tbh

I started out on Ubuntu back when it was basically just Debian with more stuff preconfigured and newer packages.
So I'm intimately familiar with the .deb ecosystem.
Moved away from Ubuntu when they started trying to push their own solutions over accepted standards (Unity, Upstart, Snap) and included ads in their OS.
Moving downstream to a Ubuntu-based distro felt wrong so I moved upstream to Debian instead.

I don't think it's the best distro out there in all respects, but it's rock solid, dependable, predictable and I know it inside out.
Plus, it lets you choose how up-to-date vs. stable you want it to be, with its testing and unstable branches, backports, apt-pinning and third-party support. And also, how bare-bones you want it to be, since it offers a minimal installation with less hassle than Arch as well as a full bells-and-whistles system with its default installation.

I use it for both. It's rock solid and once setup and customised to my liking it's low maintenance. Basically I wanted a stable Ubuntu. I wouldn't say it's a server orientated distro, it's good at both.

I used Debian years ago, but switched to Ubuntu. After using that for many years, I got frustrated with Canonical forcing snaps and switched back to Debian a few months ago.

Well,

For me its simple: i use Debian for servers, so who not for Desktops either. And personally i dont consider Debian a "server oriented distro" perse. for me its basicly a kernel with userspace software. You can make it a server if you leave it after a minimal install, or you can make it a desktop if you install a desktop environment.

Imo, why ask the question with the assumption "is based on a server-oriented distro" when "dektop distros" such as Ubuntu, Linux mint Zorin are then using debian? It is a bit conflicting isn't it? it all boils down to personal taste, if you like ubuntu, use ubuntu, if you like linux mint, go use that. If you want to use debian or arch or fedora, you know...

For me it is easy enough, stable enough, bleeding edge enough (testing/sid) to tinker around without invading my machine with stuff I don't necessary want

Because I'm a junior sysadmin. I need to learn all the stuff as fast as I can.