These days I have a good intuition as to where an agent can actually do what I want as opposed to creating spaghetti. The best analogy I have come up with is that LLMs are like water and will take the shape of the bowl you build.
The upside is that there's way more water than bowl. The catch is that you have to be the type of person who could build the bowl in the first place.