Do the adjoint functor theorems usefully dualise?
Solution 1:
as a sort of meta answer: there are more left adjoints than right adjoint (this is of course nonsense!!). More to the point, quite often we are interested in finding left adjoints to functors (in order to create free objects (which include all of the uses you mentioned)). Also quite often, the functors that typically interest us do not have right adjoints at all. This is related to the fact of life that mathematics is not self-dual. For whatever reason, many of the naturally occurring functors we meet tend to have left adjoint but often they lack right adjoints.
So, while category theory is self-dual, practiced mathematics is not. A similar phenomenon is the common concept of a cofibrantly generated model category, while there are very very few examples of naturally occurring categories that support the dual notion of a fibrantly generated model category.
Notice that this lack of duality in practiced mathematics starts very early on. The concept of cartesian product of sets is much more important than the dual notion of disjoint union. And while noticing this, it is the cartesian product of set that is at the heart of the definition of category. So the bias towards one concept over its dual is very deeply rooted.
Solution 2:
The dualizations are correct and well-known at least for category theorists. Note that the assumptions in Co-Saft are clearly satisfied if $\mathcal{C}$ is presentable. Thus, left adjoint functors $\mathcal{C} \to \mathcal{D}$ coincide with cocontinuous functors $\mathcal{C} \to \mathcal{D}$. This is a basic and important fact of presentable categories. Here is a nice application: Every presentable monoidal category (i.e. a monoidal category whose underlying category is presentable, and the tensor product should be cocontinuous in each variable) is automatically closed monoidal. In other words, as soon we have a tensor product, we get inner homs for free. In practice, often it is vice versa, but not always.
In my work cocomplete monoidal categories appear where I still have no idea how to describe the inner homs. Nevertheless, they are useful, for example in order to apply Kock's results about monoidal monads. More specifically, if we have a monoidal monad on a cocomplete monoidal category, we can quite easily write down a tensor product on the category of modules, but the proof of associativity is not trivial and actually it seems that we have to impose additional assumptions such as closedness (see arXiv:1205.0101 for details). You surely have seen this for tensor products of modules over a ring in the usual sense: The proof for $M \otimes_R (N \otimes_R K) \cong(M \otimes_R N) \otimes_R K$ only using the definition of the tensor product as a classifying object for bilinear maps is a bit tricky, because first we have to fix some element of $M$ etc, and this implicitly uses the closed structure.
Here is another application: Let $f : X \to Y$ be a morphism of schemes. Then $f^* : \mathsf{Mod}(Y) \to \mathsf{Mod}(X)$ has a right adjoint $f_*$. The functor restricted to quasi-coherent modules $f^* : \mathsf{Qcoh}(Y) \to \mathsf{Qcoh}(X)$ also has a right adjoint. When $f_*(\mathsf{Qcoh}(X)) \subseteq \mathsf{Qcoh}(Y)$, the right adjoint is $f_*$. This happens, for example, when $f$ is quasi-compact and quasi-separated. But even when this is not the case, $f^*$ has a right adjoint, since it is cocontinuous and $\mathsf{Qcoh}(Y)$ is presentable by a result of Ofer Gabber. On the other hand, it is not so easy to write down the right adjoint and probably it's not really useful. Related to that: The inclusion $\mathsf{Qcoh}(X) \hookrightarrow \mathsf{Mod}(X)$ is cocontinuous, hence has a right adjoint. This means that every sheaf of modules has a "quasi-coherator". For example, if $X$ is affine, then the quasi-coherator of $M \in \mathsf{Mod}(X)$ is $\widetilde{\Gamma(X,\mathcal{O}_X)}$. See here for more about that.
If $f : X \to Y$ is a morphism of schemes, which is affine, then $f_* : \mathsf{Qcoh}(X) \to \mathsf{Qcoh}(Y)$ is cocontinuous (actually the converse is also true by a classical result of Serre, generalized by Rydh), hence has a right adjoint. But it seems that you can only write it down when $f$ is finite. Then the right adjoint is $f^{!}(M):=\underline{\hom}_{\mathcal{O}_Y}(f_* \mathcal{O}_X,M)$. If $f$ is not finite, we have to take the quasi-coherator of $f^!(M)$.
It seems that in each application of Co-Saft, the right adjoint is either "pathological" or we can write it down directly anyway and showing the adjunction directly.