ah, yes certainly not -- that would give the "all the adjoints" situation. so if A is a commutative algebra, the composite
$- \otimes A : C \to Mod_A(C) \to C$
is automatically a left adjoint, and the first functor $C \to Mod_A(C)$ is as well. so it seems like the question is whether the second functor is also a left adjoint, and maybe this is where finitely-presented (and idempotent) comes into play