I LOVE LOVE LOVE these! They give off different type of auras which comes in handy when you need some type of mood. I set the romantic ones in the bedrooms, confident/inspiration ones on computer desk...
I've often used the plain white one just as a different small table lamp. It's a good true-white light in the middle of a dining table for face-lighting too. Some Sim couples (and a couple of Sim singles) have the red one in their bedrooms too :)