Well, for my sewing machine, I have the overhead fan/light combination, the sewing machine's light, and a floor Ott light with the flexible neck, clamp and magnifier, which I love. Behind me sitting at the sewing machine is the window, so not much help at the machine.
I have a clamp on flex neck lamp on the right end of the sewing desk to help looking at fabrics in that area. I have 2 clamp on lamps on my fabric cabinet, one with flex neck and one not. The one not is aimed at my other desk, which I am soon going to replace with the cutting/ironing table I am working on.