I picked up an illuminated magnifier from Lidl a while back. It has a set of white LED's and the colour balance seems pretty good really, and the magnifier is large and clear and works very well indeed. The fact that it was knocked down from £30 to a fiver just made it sweeter!
Before that I had two different "daylight" low energy fluorescents. One (the second, more expensive one) was adequate (though not as good as the LED or the halogen), the first one I got was frankly bloody awful. I think it must have been matched to daylight somewhere other than on planet earth.
Before that I had a cheap halogen lamp, which actually worked really, really well but I couldn't replace it when the internal transformer died.
The halogen lamp kicked out a LOT of heat, which reduced the open time of paint on the brush but was very handy for rapidly drying stuff.