Freyd's adjoint functor theorem states that a continuous functor $R: \mathsf{C} \to \mathsf{D}$ has a left adjoint if its domain $\mathsf{C}$ is locally small and complete, and $R$ satisfies the solution set condition. Moreover, the proof constructs the left adjoint as a limit.
Also, we know that if $L$ exists then it is given by the Right Kan extension $$L \cong \operatorname{Ran}_R 1_{\mathsf{C}} \cong \int_{c \in \mathsf{C}} c^{\mathsf{D}(-,Rc)},$$ whose pointwise formula is an end, and hence a weighted limit.
However, it seems that plenty of left adjoints seem to be given by colimit formulas. For instance, the inverse image of (pre)sheaves is given by a colimit formula and also in the answer to another question of mine, Roland explains that a far left adjoint to inverse image of sheaves (when the map of spaces is etale) can be constructed as a colimit as well.
Also, in algebra, the left adjoint to the internal hom (i.e. tensor product) of (bi)modules is constructed as a coend, which is a colimit.
Is there a reason why so many left adjoints are given by weighted colimit formulas, even though they are right Kan extensions, and hence weighted limits? Is there a general weighted colimit or coend formula for left adjoints under certain circumstances?
Freyd's Adjoint Functor Theorem states that if a limit-preserving (aka continuous) functor $R : \mathsf{C \to D}$, where $\mathsf{C}$ is locally small and complete, satisfies the solution set condition, then it is a right adjoint. In my opinion, the main condition is the continuity one. This is underscored by e.g. posets, toposes, and (particularly for the dual statement regarding left adjoints) locally presentable categories.
A left adjoint has to preserve colimits. For, e.g. locally presentable categories, that is all it needs to do to be a left adjoint. In general, since colimits commute with each other, functors defined by colimits are a natural place to look for left adjoints. (Dually, for right adjoints.) Conversely, a reason why a left adjoint preserves all colimits may be because it is itself a colimit, so it's natural to wonder if a left adjoint can be reexpressed as a colimit. As a simple example, as $\mathbf{Set}$ is locally presentable, any left adjoint $\mathbf{Set}\to\mathbf{Set}$ is a colimit. Since $X\times - : \mathbf{Set}\to\mathbf{Set}$ is a left adjoint, it is also expressible as a colimit, namely $\coprod_{x\in X} -$.