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.

SharePoint (MOSS and WSS -- does offer some out of the box workflows, but there are basic. You can add new workflow by creating them in either Visual Studio or SharePoint Designer.