@gannet@wandering.shop I got this one a while ago: https://www.lidl.nl/p/livarno-home-led-loeplamp/p100367002

Mechanically it's been great; well-balanced, stays almost exactly in the position you put it in, large range of movement, large magnifying area. Quite bright and good light quality (though very cold white light). Comes with a strong (screw, not spring) clamp.

The optics of the magnifier are alright, but not the best I've ever seen. Plastic lens, only some chromatic aberration around the edges - I've found it more than enough for my uses, but I'm sure that better options exist on that front.

(It seems to be a generic model; if you don't have a Lidl selling it, there will probably be other stores selling it under another brand but with the same design)