Well suited for simple workflows and easy conversion of lookup fields to text. Not well suited for complex workflows. Not well suited for cross-site lookups. The issue I am facing is that we have a list of all shop locations. The list lives on the root site of one of our 3 site collections and has many details about each shop. There is also managed metadata with just the shop location name to be used as a lookup field in many lists in all three site collections. This can't be accomplished in SharePoint Designer.