Unfortunately, this is not a new problem. I have personally spent tens of thousands of dollars on licenses for software in the past that promised much, but was functionally crippled or even inoperable. Authors of Photoshop and After Effects Plugins are particularly guilty of this problem and only the weight of bad reviews tends to drive them out of the market. Too bad you have to waste your money, time and good faith to prove to the World that a software package is unusable...
I once spent $30K USD on a software/hardware package for digital film restoration that drove me insane for 5 years as I had to beat product out of it's interface, all the while the support team insisted that the software was fine and that I needed to "tweak it a bit".
Have you tried Darktable (
https://www.darktable.org/) or RawTherepe (
https://rawtherapee.com/)? Both are free to download and Open Source, but both have their limitations. I think you may find you have to hammer out a workflow using multiple Open Source packages to arrive at a satisfactory outcome, but even if you go the Adobe route, you wind up having to supplement with plugins and other packages.
The problem arises when we seek simple solutions that promise easy answers. The answer is that nothing in digital manipulation is easy beyond the most basic tasks and you have to armor yourself with knowledge and experience to chart a meaningful path through all the soulless hype and marketing BS.