I think the answer to your question about why it’s frustrating for some people and not others has a lot to do with use case.
One use case that easily makes Linux way less frustrating is of developing software, especially in low-level languages. If you’re writing and debugging software, reading documentation is something you do every day, which makes it a lot easier. Most of the issues where people break their systems, don’t know how it happened, and can’t figure out how to fix it are because they default to copying bash commands from a Wordpress blog from 2007 instead of actually reading the documentation for their system. If you’re developing software, a log of the software you’re installing and using is open source, so you benefit tremendously from a package manager that’s baked into the OS.
If your use case is anything like that, Windows in particular is way more frustrating to use IMO.
If instead your use case is using a web browser and a collection of proprietary closed-source GUI tools, then most of the benefits that you’re getting using Linux are more ephemeral. You get the benefit of using a free and open source OS, not being tied into something that built to spy on you, not supporting companies that use copyrights to limit the free access of information and tools, etc. Those benefits are great and super important, and I would still recommend Linux if you’re up to it, but they definitely don’t make computing any easier.
If your use case is anything like the second one, you’re probably used to following online guides without needing to understand how each step works, and you’re probably used to expecting that software will make it hard for you to break it in a meaningful way. Both of those things directly contribute to making Linux might be frustrating to use at times for you.
If you’re in the second category, the best advice is to get used to going to the official webpage for the applications you use and actually reading the docs. When you run into a problem, try to find information about it the docs. It’s fine to use guides or other resources, but whenever you do, try to look up the docs for the commands that you’re using and actually understand what you’re doing. RTFM is a thing for a reason haha.