The six functor formalism in a given cohomology theory consists of for each space a derived category of sheaves and six different ways to construct functors between those categories (four involving a morphism and two only a single space). It then consists of many coherences - these are isomorphisms between certain compositions of these functors and, in modern formulations, homotopies between certain combinations of these isomorphisms, 2-homotopies between certain compositions of these homotopies, and so on.
In Peter Scholze's notes on six functor formalisms he gives a precise definition, attributed to Lukas Mann, and closes it by saying:
We note that no further coherences are necessary here: Adjoints automatically acquire all relevant coherences.
What mathematical claim is being made here? How do we know the coherences acquired are all the relevant ones? Does that knowledge give us an algorithm to prove a desired coherence results?
In the case of a three-functor formalism, including only $\otimes, f^*, f_!$ (i.e. ignoring the adjoints mentioned in the quoted passage), I know basically how to answer all these questions. The three-functor formalism is a functor from a certain infinity-category of correspondences to the infinity-category of all infinity-categories. Each functor arises from a correspondence, so a composition of functors arises from a composition of correspondences. Checking two functors are isomorphic means computing the relevant correspondences and checking they're isomorphic, and this works for all the classical isomorphisms of the six functors formalism that involve only those functors (Leray spectral sequence with compact supports, symmetry and associativity of tensor product, functoriality of pullback, Künneth formula, proper base change, projection formula, tensor products are compatible with pullbacks). Checking two such isomorphisms are the same means evaluating two isomorphisms of correspondences, which ultimately give isomorphisms of schemes, and checking they're the same.
But when adjoints appear I no longer no how to do this. Am I supposed to draw some diagrams in which correspondences are connected with strings?