What I have is not very attractive nor is it ugly, but it is very useful: Right in front of my windows, I have a shop light (2 long fluorescent bulbs) hanging on neat little chains from hooks (toggled??) in the ceiling. The lights hang low enough to be situated about half-way between the ceiling and my sewing machine. Although I need glasses for distance, I see very well up close if I have good lighting. This shop light works well for me and I keep it plugged into a surge protector, which has 7 outlets, enough for my iron, my sewing machine, stereo components, etc. When I flip on the surge protector switch, the light comes on and also gives power to all those other things I need for sewing, etc. It's very convenient and works well for me. I've had those same 2 bulbs in there for many years.
Downstairs, I have a 4-bulb fluorescent ceiling light over my cutting table which also works very well unless the bulbs decide to be tempermental. Two of them are giving me fits right now and to adjust or change them, the easiest way is for me to carefully climb up on my cutting table. Once I get the light cover off, the lights immediately start working and when I've climbed down from the table and put my quilt stuff back on it, the lights start playing games again. It's just a matter of time, but I WILL win that war!