This has likewise been my experience; it's exactly the OS that I want, but it's definitely better suited to programmers and other techies unless you have such a friend you can call on when you need to do something non-trivial.
If you're up for getting your hands dirty though, it's a gift that keeps giving.
That is true up to a point, but getting it to do actual work gets easier with experience. Most power users just jump to MacOS, or adapt to a Linux flavor.
Windows can't help screwing with users, and has been an IT security liability for years. When Microsoft abandoned backward compatibility for much of their installed base in Win11... they also removed 99.9% of the reason IT puts up with their BS. =3
If you're up for getting your hands dirty though, it's a gift that keeps giving.