We use Cocoon mainly for Rapid Web Application Development:
RDBMS: PostgreSQL, MySQL, MsSQL
Reporting/publishing: FOP, XLSSerializer, RtfGeneration
I am anxiously waiting for Woody 1.0 release and hopefully capable to participate in UnifiedSQLTransformerAndLogicsheet work etc. in the future.
Right now my big question is how to manipulate our databases if||when we switch to Cocoon Forms.
I'm not too excited about the O/R idea (yet) because we use also stored procedures and I'd like to keep things relatively simple.