there are definitely more limitations on workflows (with a few exceptions like lock record which is only available on workflows and not in scripts), but the overall advantage IMO is that it is more accessible for non-developers, which is useful when a netsuite admin who isn't technical might want to make adjustments. i think workflows are also easier to use (more intuitive to me) in cases of literal "flows", most commonly approvals where you want a record to stay in a particular state waiting for a next action. however, as a developer it's usually way faster to write a script even if I could do the same thing with a workflow, so i lean towards writing scripts unless it's something where it's likely to need updates in the future by the client. (as a consultant, most of my clients don't have their own developers so at best they'd have a netsuite admin who could make a workflow change)