Equivalences from tilting theory and commutative algebra from the adjoint functor point of view