What's up with green desk lamps?
Green has a calming effect on one's mood, so maybe a green desk lamp neutralizes the effects of a stressful day at your work desk. Just guessing.
USB LED desk lamp?
Yes, it'll turn off when suspended, hibernating, and when shutdown. You "may" be able to adjust your settings so that when sleeping, the USB ports remain active. Go to the control panel > power settings and see if that option is availbe for your comp...
Children lamps?
floor lamps? Go to ikea.com and look under lamps. For a great lighting idea, use rope lighting, hang from ceiling with a form you make out of an old hanger and parachute material.