Assuming (M) (= there is only a set of measurable cardinals), the category $\bf{Vec}$ of vector spaces
(over every field) has a small dense subcategory. This is an old result of Isbell (see also
https://arxiv.org/pdf/1812.10649.pdf). Hence $\bf{Vec}$$^{\text{op}}$ is boundable, i.e., it can be fully embedded
to a category of algebras (I do not know whether to a category of modules).
Hence the set-theoretical strength of "no opposite category of modules is boundable" lies between $\neg$(M) and VP.
Moreover, the existence of a full embedding of $\bf{Ab}^{op}$ to $\bf{Mod}$ $R$ implies WVP (weak Vopěnka's principle) is false.
Indeed, the accessible category of graphs with monomorphisms can be fully embedded to the category $\bf{Gra}$
of graphs. A. J. Przezdziecki https://arxiv.org/pdf/1104.5689.pdf constructed an embedding $G:\bf{Gra}\to\bf{Ab}$
such that $\bf{Ab}$$(GX,GY)$ is the free abelian group on $\bf{Gra}$$(X,Y)$. This yields $R$-modules $A_i$
indexed by ordinals such that the only morphisms $A_i\to A_j$, $i<j$ are $0$ and there are non-zero morphisms
$A_j\to A_i$ for every $i<j$. Let $X_i\subseteq A_i$ consist of elements $x_i\neq 0$ such that for every $i<j$
there is $y_j\in A_j$ and $f:A_j\to A_I$ with $x_i=f(y_j)$. We have $X_i\neq\emptyset$ for every $i$. Otherwise,
every element $0\neq z\in A_i$ would have a height $k$, i.e., the smallest ordinal such that $z$ is not
in the image of any $f:A_k\to A_i$. Since these heights are arbitrarily large and $A_i$ is a set, we get
a contradiction. Add to $\bf{Ab}$ a unary relation and interpret it on $A_i$ as $X_i$. Homomorphisms $A_j\to A_i$,
$i<j$ preserve these relations but $0:A_i\to A_j$, $i<j$ do not. Hence sWVP (semiweak Vopěnka's principle) does
not hold. Following the recent result of T. M. Wilson https://arxiv.org/pdf/1909.09333.pdf, WVP does not hold.