Let $R$ be a ring and $M$ be an $R$-module. Say that $M$ is cocompact if the functor $\operatorname{Hom}(-,M)$ turns filtered limits into filtered colimits. (This is just saying that $M$ is compact as an object of $R\text{-Mod}^{op}$.) My question is:
Is it possible for a nonzero module $M$ to be cocompact?
I suspect the answer is no. For instance, by considering an infinite product as the inverse limit of finite subproducts, it is easy to show that if $R$ is a field then no nonzero vector space is cocompact.
More strongly, I can prove the answer is no assuming that there exists a proper class of measurable cardinals. Indeed, suppose $M$ is a nonzero module and $\kappa>|M|$ is a measurable cardinal. Let $U$ be a nonprincipal $\kappa$-complete ultrafilter on $\kappa$. There is then a homomorphism $L:M^\kappa\to M$ that sends a function $f:\kappa\to M$ to the unique element $m\in M$ such that $f^{-1}(\{m\})\in U$. Since $U$ is nonprincipal and $M$ is nonzero, $L$ does not factor through any finite subproduct of $M^\kappa$, and so $\operatorname{Hom}(-,M)$ does not preserve the limit of the inverse system consisting of finite subproducts of $M^\kappa$.
On the other hand, without assuming a measurable cardinal, I have not even been able to prove that $\mathbb{Z}$ is not cocompact as a $\mathbb{Z}$-module.