In my opinion, Debian is best for small, specific purposes that don't change much over time. I used Debian for a bit as a home PC, mostly for making music with bitwig and gaming on steam as well as freetube/media consumption.

I had trouble with apps having conflicts, and combined with an nvidia card, the experience got worse over time and I had to separate my system into different bootable linux systems on the same drive, one distro for gaming and one for music. Some apps were deb files, some were apt, some were direct from websites and others immutable type apps, a mess.

Eventually I tried Arch based systems and liked how unified pacman is and how there are meta-packages full of music and RT. Then moved to Cachyos because it is just so much less annoying that vanilla Arch maintenance for me. I also used endeavorOS for a while, but at one point started having endless crashes from that distro across 2 different PCs (some black screen video issue with nvidia GPU).

As to how that applies to what I would recommend:

I think Debian is good at specific use-cases, but poor as an everyday home PC imo. Also, Debian is so barebones that things like a firewall aren't pre-configured, which makes it more of an intermediate distro that seems easy on first glance.

I wouldn't recommend Ubuntu personally, because the last few times I have tried it I found it buggy and I don't like snaps. But there are so many Debian derivative distros that in some cases Ubuntu is the best option, for example, Ubuntu Studio is actually pretty nice for quickly making creative content. There also Ubuntu distros pre-configured for other purposes.

Linux Mint seems to have outdated packages, but overall decent for beginners because it is a debian/ubuntu sub-distro that has a lot of polish and is really good at hardware detection on installation. I also think the linux mint DE is pretty good for new users.