In lots of different cases (Verdier duality, Grothendieck duality, étale cohomology, ...) the very existence of a (right) adjoint to the sheaf functor $f_!$ gives useful information. (I'm going to ignore whether the functors are derived or not.)
As it appears, in many of those same cases, the functor $f^*$ also has a left adjoint, which seems to be denoted as $f_\sharp$ in some places. (Examples: this paper talks about this in Grothendieck duality and these notes talk about this for $f$ smooth.)
Beyond implying that $f^*$ is exact, which we already often know, does this functor gives any meaningful information? I would appreciate knowing anything about it!