> The smaller the focal length of the external lens and bigger - of built-in camera's optics, the greater magnification is achieved, but less depth of field is obtained. Compact camera, with a sensor of small physical size, have an advantage over DSLRs in the depth of field and mobility, allowing you to take pictures quickly and easily change the location and shooting angle. But small sensor have much higher noise level.
However, a larger sensor probably would have larger pixels, which would help with lighting and noise reduction.
You actually don't need the telephoto, though. You can get a reversing ring that mounts a prime lens directly to the camera. I took this using a 50mm lens on a full frame body, no focus stacking: https://c1.staticflickr.com/1/498/19387253482_cfdb183b3a_c.j...
If you use a shorter focal length lens, you'll get a higher magnification. I've used a 28mm in the past but wasn't very happy with the image quality.