Earlier today I presented on Connecting Office Client, SharePoint, Search, and Workflow. It's one of my favorite talks because it shows an end-to-end solution from getting data from the end users through promoting the properties in SharePoint, making them searchable, and taking action via workflows. In the presentation I referred to a few tools and resources. They are:

• Andrew Connell's STSADM extensions for WCM -- they allow you to export the content type and site columns you created in the user interface into XML files that can be used in a feature to deploy the content type across multiple site collections.
• Managing Enterprise Metadata with Content Types -- A written step-by-step guide for making data available via search.
• Workflow Development Resources
  • Wrangling SharePoint Workflows in Visual Studio (Robert Bogue) -- An aging article on how to do SharePoint workflows with SharePoint.
  • Workflow in the 2007 Microsoft Office System (David Mann) -- The book on workflow in SharePoint.
  • Real World SharePoint 2007 (MS SharePoint MVPs) - A good book on SharePoint including two chapters on workflow -- one of which is mine.
  • Delivering Modular SharePoint Workflow Functionality Pt 1 of 2(David Mann) -- Article on MSDN
  • Delivering Modular SharePoint Workflow Functionality Pt 2 of 2 (David Mann) -- the rest of the content.
• MSSharePointDeveloper.com - "How To" develop for SharePoint -- including a Workflow webcast and hands on lab
• MS Patterns and Practices SharePoint Guidance -- "When" and "Why" to use SharePoint features.

Good luck on your next project to make life easier to get data in -- and used in your organization.