Yes, you can create workflows for SharePoint lists in SharePoint Designer, but they aren't the most robust workflows you may need for your organization.

Microsoft is giving away SharePoint Designer 2007, an entry level application customization tool that previously cost $299.95, in order to get more customers innovating on the SharePoint platform.