I had bad experiences with Arch before because of Manjaro, but in hindsight, I think the main issues I had were more to do with how Pacman can get insanely nuanced. When you update packages you have to know what you're doing, it will update all weird, its not like Debian or Ubuntu upgrades where it installs / uninstalls what you do and don't need unless you tell it to be that nuanced.
From my own experience: 15 years ago, when (except for academia), Linux was very nisje, it was hard to use it. Random rare errors would pop up. On Windows you would know someone who knew what to do, but with Linux? So I chose Ubuntu, because it had the most support. Solution to any error could be found on askubuntu (?) forums. But if you had a friend, you would choose his system and get help from him. I once had university admins very happy to help me with something and even give me some tips.
Nowadays it really doesn't matter that much, other than extra easy (with an LLM everything is already easy) installation of drivers (POP os?)/initial programs you used on Windows (on Mate it takes 10min due to a special GUI appstore).
BUT there are reasons to switch. Like Ubuntu's pushing of very annoying snaps, making it very hard to get Firefox without a snap. Snaps are annoying, because they don't have a cleaning mechanism and old versions just clog your hard drive. They take forever to launch and it's just not a good idea for a browser. Don't mind snaps for other things. There is also Desktop Environment support and support for hidpi monitors and such.
Other than that, there is a little of philosophy. Like super FOSS and idealistic like Debian (i guess? Pls correct me if I'm wrong). Or more business aligned, like Redhat/Fedora. Or elitist that like to waste their users time and make them read manuals for fdisk like Arch, where you have to format your hard drive without GParted or any other GUI.
I'm no pro, but that's a little that came to mind if you wanted to know what mattered in the past.
My homeserver is Ubuntu, my gaming PC is Arch.