For certain use-cases (like constructing queries for an ORM) or other things where you're effectively passing around curried ideas to eventually be executed, I think cascading methods is a huge win.
Severely, since what you're doing is mutating the actual state-data of the query object.