Depends on what you are doing. Illuminated anglepoise type works fine for my wife with sewing, embroidery type jobs.
I am rather fond of "Peer" binocular magnifiers. Mine have no light but a separate small halogen desk light does the job.
I have a (cheap) pair of surgeon's magnifiers (basically a little pair of Gallilean binoculars which clip on to my glasses) but don't find them particularly effective. For high mag without a doubt the best thing is a stereo microscope with through the lens illumination, on a good solid stand.