Lightbox2 module does not allow hover?
I would install both module, set the Lightbox field format in your view, and then try to replicate the output used by the hover_preview module. If you use the browser inspector you will notice that you need two images in top of each other and some classes assigned to them in order to work.

In your view, add those images fields and rewrite the results. See image attached. I hope it helps.