I've been wondering about the same thing recently and here's my best guess. Let $\widetilde C$ denote the Cauchy completion of $C$. if the associated functor $\widetilde F : \widetilde C \to \widetilde D$ induces a bijection of the sets isomorphism classes of objects in $\widetilde C$ and $\widetilde D$, then $\Delta_F$ is monadic.
Here's a rough idea why this is true. The monad $M$ is given by a coend formula $M X = \int^c X c \times D(F c, F-)$. For simplicity let's assume that $C$ and $D$ are Cauchy complete (we can do this since $C$ and $\widetilde C$ are Morita equivalent) and $F$ is actually bijective on objects (replace $C$ and $D$ by their skeleta). Now a map $M X \to X$ is a transformation $X c \times D(F c, F c') \to X c'$ dinatural in $c$ and natural in $c'$ i.e. a transformation $D(F c, F c') \to \mathrm{Set}(X c, X c')$ natural in both in $c$ and $c'$. Since $F$ is bijective on objects we can rewrite it as $D(d, d') \to \mathrm{Set}(X d, X d')$ where $X (F c) = X c$. At this point this is just a family of maps and I do not claim any compatibility with composition in $D$. However, if $M X \to X$ is an $M$-algebra structure on $X$, then this family actually obtains a structure of a functor $D \to \mathrm{Set}$. It shouldn't be to difficult to verify (I admit I haven't done it in full detail myself) that this is an inverse to the canonical functor $\mathrm{Set}^D \to M$-$\mathrm{Alg}$.
I also have reasons to believe that the essential surjectivity is necessary. Here's a very rough idea why I suspect this. If $F$ is not essentially surjective, then we seem not to be able to control the behavior of functors $D \to \mathrm{Set}$ by means of $M$-algebra structure. If I wanted to try to actually verify this, I would try to show that in that case $\Delta_F$ fails to create limits. (This is what fails when $C$ is the terminal category and $D$ is a two-point discrete category.)
On the other hand I don't know whether the injectivity on the isomorphism classes is necessary.
I also don't know any answer to your second question and in fact I don't see any non-trivial example of $F$ such that $\Pi_F$ is monadic (if you have such an example, please share it).