I did some more "tests" with the microscope to see what the magnifications are.
The in the sales add mentioned x150 for the lens is actually correct. At a distance of ~5.5 cm from the PCB the magnification is near 150. (1mm in real life measures as ~150mm on the screen) The lens is then turned to its extreme, and the camera height needs to de adjusted to make the image sharp.
On the other end of the lens setting the pole of the stand is to short to get a good image, and going on the sales add the distance has to be a meter for a x1 image.
At the top of the pole, with the lens at a distance of about 50cm from the PCB the magnification is just over 7. (10mm in real life measures as ~70mm on the screen)
So to get a good image at a certain magnification the height of the lens has to be set and then the lens has to be tuned to make the image sharp. For a soldering job you probably do this only once at the start of the job, and maybe readjust to later inspect the work.
For close up the LED ring works better than the two swan necked LED lights, but the mounting is a bit flaky near the end of the lens. Not sure if I will be using that often. Also the fit of the swan necked lights on the base is not that solid. It needs something extra between the clip to make it firm.
A magnification of 7 to 15 works very well for soldering, at least for me, just by what I have seen so far. Have to do an actual soldering job though.
I don't think that a camera with a Sony sensor will provide a much better result. I feel it depends much more on the quality of the lens, and as a hobbyist this one is good enough. Maybe when you have to solder day in and day out and make a living with it, it could be justified to spend 5 or 6 times as much money.
As a final note, if you like it to be a bit cheaper, you can consider one with a x1 - x130 lens, since you most likely won't be needing the extra magnification.