I recently got my AOW so I wanted to just add some opinions based on my experience.
I managed to find a shop that charged a minimal rate beyond the PADI fees in addition to a multiday dive package so cost wasn't crazy.
The actual written section is straightforward, and informative. Most of it didn't feel all that critical (see Fish ID) and some things like boat diver are so standard it seems silly to even mention.
The training dives weren't anything special, but they do reinforce some skills and if you have a decent instructor, there's at least some useful takeaways, although probably not loads you couldn't figure out by yourself in a pool. Personally I practiced with my kit a fair amount so I didn't notice loads.
However... on my recent week trip to the Caribbean, I noticed that nearly every other diver off the boat had, lets say areas for improvement. Some were pretty minor, but some clearly could have benefited from some 1 on 1 instruction for trim and buoyancy, situational awareness etc. Most were good enough, but a few were properly oblivious, and clearly had either forgotten or ignored all the technically boring things AOW repeats. I'm not particular surprised to hear some shops going light / skipping the training, because wherever these people got certified certainly did the same.
Last, my dive buddy had certs from both SSI and PADI, and had a strong preference for SSI based on the shop taking things a bit more thoroughly. Just a thought.