The quality of the lens from the Pi camera is remarkable (Comparison of a pi-camera and a 20x optical lens)
I think that is a great solution if cost is an issue and very little quality is sacrificed. A high power microscope objective in the optimum configuration with a tube lens will give high resolution. If you move away from optimum performance by not using the tube lens, how much better than the simple Pi camera lens does it end up being?