You’re right, Twitter makes it hard to be clear...
I’ll set up a Drupal install with the module for you to play with, and send you a PM, probably next week...
For the record I was referring to a project I am working on, which requires custom workflow and I had to go for Drupal to handle that. The twitter quotes refer to how Drupal workflow module work. This is a big module, with pretty advanced settings (custom statuses, handles roles and permissions, is tied to trigger actions for every scenario in one way and the other e.g archived -> published, trash -> draft or whatever is imaginable). Along with the taxonomy module I think those are industry benchmarks of what can be done in those areas.
Yes with the Drupal module you can have as many workflows as you like, which is probably overkill in many cases but not in this specific case where there are a LOT of content. Drupal allows for different content types and you can even go granular by defining which workflow applies to which content type.
Wikipedia’s definition is wide, and maybe not specific enough for document workflow.
How would I define a workflow ?
Well, to me it’s a structured process a document goes through from draft to publishing to archiving to trashing. Each step requires a validation process by an authorized person. This person can be different for each step, and that’s where Roles and permission come to play. Each validation has an effect on the content status (published, promoted to frontpage, archived... etc).
Those are the common steps but in some cases you have several reviews / validation before a document gets published. Now I am talking complex workflow which will only be useful in a handful of cases. IMHO we should stick to simpler things with no customizable workflow.
As for WordPress and workflow, there is a pretty interresting codex article :
http://codex.wordpress.org/User:Scompt/Workflow_With_WordPress
Workflow is useful when you are in the context of multiple authors, and even more so when you manage a lot of content, with frequent publishing. It’s also useful mainly in the context of webzines, web publishing but not so critical to corporate websites. I know I never had a use for it before.