form builder

I'm new to Drupal. I'm hoping to use it to build a workflow management application wherein privileged users can define perhaps a dozen forms to collect data from a large, distributed group of users. Each of these forms will experience some edits, changes of state, etc as they get processed by the workflow.

Can anyone tell me how this might work in drupal? Obviously I'll need the worfklow module installed. I've seen a 'form builder' module but it has a big warning about not being suitable for a production environment:
http://drupal.org/project/form_builder

This is just an idea.

We've built sites on Mambo/Joomla in the past. mosforms, an extension to build and output custom forms and store the input much like CCK works for Drupal, was yet a simple, but great component to design site contact and other forms for Joomla. mosforms has evolved and is available as Fabrik - Joomla Application Builder now. There is nothing that might compete with our CCK here, but the last line of the published roadmap for Fabrik sounds quite interesting to me:

We've talked about future CCK tie-ins to the form builder, and are keeping this in mind as a future add-on.

What about Views?

Views module provides a code-accessible representation of tables, fields, etc. Presumably, on this basis we could pre-populate a draft form array, or provide a data reference for the form builder (default values for fields, etc.).