A big Pro for workflow is that the canvas looks pretty. You can show it to your non-technical people and explain it at a high level. Compare that to automation scripts where you are showing them a foreign language.
A big Con for workflow, in my experience, is the inflexibility of Action Groups. If one of those is used in a workflow and you need to change the sequence or remove particular actions, woe betide you.
Like Craig said, Workflow tends to be used to control status changes. You either have your users use the Change Status icons, or you take all of those away and give them the Route Workflow icon. I try to avoid assignments altogether, so you never have to use Workflow Administration. Since nothing can get stuck in an assignment, admins can have Change Status, maybe in a different app, for emergency situations. A con of going this way is that you have to use code (Autoscript or Java) to copy memos from the workflow box to the status change audit record.
------------------------------
Blessings,
Jason Uppenborn
Sr. Technical Maximo Consultant
Ontracks Consulting
------------------------------