@log I can comment on two use cases:

1. If you're unhappy about getting stuck on technical problems but you want to be liberated by being able to fix deeply technical issues yourself, one avenue is to learn about the internals. Gentoo was (still is?) a good way to do this for me when I used it until about 12 years ago. You get to compile everything by yourself. The distribution is designed for this and it's very interesting but it gets tiring because compiling all the packages takes ages.
2. If you want something that just works, the latest LTS (long-term support) release of Ubuntu is a good choice. Do not expect it to just work but with a bit of luck, it might.

I haven't spent much time looking for the ideal Linux distribution in a while, so they may be better info out there.