Brian Williams: Indiana Jones Layout at Brickworld 2009
A great example of how lighting can dramatically improve the end result when photographing LEGO creations.
More of Brian's creations, including, his entire Indiana Jones layout can be found on his Flickr photostream.
Lighting can be added with LEGO (R) Power Functions lights, or there are other options like LifeLites usually using LEDs and batteries for safety and small size. See how he has made a flickering flame effect at http://www.flickr.com/photos/brian_williams/4956564745/
More ideas and options from at www.lifelites.com