Also check on threads here discussing the existing CMS (UI sucks, much of the included functionality does not) and the content repository. The CMS/CR allows for the attaching of templates to content types or individual template items, automatic form generation and handling (only useful for simple page flow and content input but better than nothing) and other stuff. Jeff Davis has been working hard to make these work as they were originally designed by Ars Digita, in both Oracle and Postgres.
Also if you're not already familiar with the templating system's form builder package, study it and the ad_form wrapper function we now use to write self-submit form generation and handling scripts. Makes things much simpler. The autogenerated forms mentioned above also uses the templating system's form builder package so you can customize the look of input forms site-wide by writing one new template file.
Workflow - we have a new, simplified workflow package courtesy of Lars Pind, who wrote the original acs-workflow while at Ars Digita. The new one uses a finite-state machine model rather than petri nets - FSMs are sufficient for the simple workflow requirements we've run into and relatively few people are familiar with Petri nets.