This is a great article on building workflows on SharePoint 2010.  It gives you an overview of the capabilities of the Out of the box, SharePoint Designer and custom Visual Studio workflows and helps you decide the best approaqch and best practice for creating them.

http://msdn.microsoft.com/en-us/library/hh237664.aspx