Mark, in two sentences, you got it absolutely spot on!
Photoshop is immensely powerful, and arcane and obscure. Probably because it predates both Apple and Windows GUIs (which they both stole from Xerox PARC ... ).
I agree with Tony about Lightroom ... However, Photoshop actions (really just macros) are pretty easy after you jump through the initial stupid hoops!
Oops. Meant to add that I never use automated processing on RAW files, but I can see the utility of Tony's approach to his swallow problem.