I have one of those huge ceiling fan/light as the main source of light that I just hate - the worst is that the fan itself is merely moving air, so it's useless. I plan on getting rid of it as soon as we buy the place, and replace it with a simpler lighting device and put a vertical fan somewhere in the room instead.
I prefer the place to be as dark as possible when I'm working, so the ceiling light is off the minute I launch Logic. Meaning that I'm kind of stuck with the same problem as you were. I have a little lamp which used to be in the back of the studio that I brought closer to my desk, but it means things are a bit off balance. For someone w/ OCD tendencies like me, that's not good.
Unfortunately, those lamps are only available in a store which my wife and I have boycotted, so there's no chance of me getting a new one. I guess I'll have to come up with a different solution.
I do have a lava lamp, but I tend to forget about it...