It’s sad, when you think about it, because I was under the impression that Linux was perfect for old/ancient machines, but if support for old hardware gets thrown away…

You can even not use DE, some people use only Window Managers (with additional things), or even just terminal.

I’ve also heard that not many people like Ubuntu because of snaps, why is that?

Well, people don’t like snaps for a number of reasons, because they are forced on users, bloated and slow, Canonicals themselves are quite shady, systemd, etc.

I would rather use several different types of packages than trust one that is tied to a shady company.

I don’t know what you mean by “A distro that allows you to easily switch between KDE and GNOME”, because any distro that has both should be able to easily switch between KDE and GNOME. As for user-friendly, something like Ubuntu or Mint, maybe Manjaro and Pop, EndeavourOS if you don’t mind learning and don’t mind using a terminal.

I’ve been hopping between different distros since 2023, but every time I come back to EndeavourOS, this distro seems to work the best for me, haven’t had any problems with this distro.

LXQT. Why? Because: It is lightweight, consumes little resources, is quite customizable, and has full Ukrainian localization.

Maybe I’ll switch to XFCE/MATE, but not if there are a lot of things not translated, or if the translation is worse than even Google Translate.