I guess I'm going to be the odd person out. I don't care for the Ott lamps; I find them horribly overpriced. I purchased a "daylight" bulb, recommended by Holly Knott for getting true colors when photographing your quilts. I liked it so much I installed it over my sewing work area - and the bulbs fit standard fixtures, you don't have to purchase an expensive specialty lamp. The bulbs should have a rating of 5000K.
For close-up work and handwork, especially when I sit in the family room with my husband and we watch foot ball together, I bought one of these LED lights (called Jansjo) from IKEA for $10. It's perfect - it doesn't knock everyone else out of the room with a bright, blinding light, and I can focus it directly on my work. The arm is flexible but stiff, so it stays where I put it. My mom liked mine so much, she bought one for herself for doing hand embroidery. They come in 3 models; tabletop, clamp-on, and floor.