It depends on what you are really asking. Are you asking can people use this in all its aspect of technology, have mastered all the intricacies of the program? Or are you asking is it a program that only absolute professionals would use? Or are you asking what people use Photoshop for?
As there are already a lot of postings here from camera RAW people I will answer this question as a more than normal user for graphics. I do work for my spiritual organization - creating Visualizations and videos. In most instances I am taking a already created outside image and making changes to it - it may become many layers deep and take a week or more to complete. But I also create images starting with vectors, moving them over to Ps to add effects.
I find Ps and Ai are overkill for my needs. I tend to use the same tools mostly, over and over. I found Affinity easier - as I still have an Ai subscription that doesn't expire until Dec I am still using it, but I intend to move over to Designer when it does. I found for instance that Refinement Selection is a much better tool in Affinity than in Ps so that is what made me move to Affinity initially. Along with that nothing in Affinity is hidden, everything is where you can find it easily and you don't have to go searching through endless menus to find some new tool.
Affinity is faster and takes less RAM to run so for my purposes, I will stay with Affinity and grow with it. The tutorials are easier because Affinity is a more intuitive program than Ps. Plus everyone has to ask themselves - do they really want to be tied by a money string every single month for infinity to Adobe? And what if they raise the rates?