Excellent Aperture web feature on Gregory Crewdson. His work is amazing. I thought my process of shooting my Three Minute Series was complex, but his process makes me feel inadequate.
Equally fantastic is the night series by Jan Staller. Check out the Frontier New York series. Like Crewdson, they make images as opposed to taking them. Unlike Crewdson, he doesn't phsically construct the scene. Rather, he explored the familiar areas around him and photographed them in a manner which makes them seem simultaneously familiar and unfamiliar. One of the significant things about Staller is the seeming insignificance of what he photographs. He doesn't seek out the most obvious chooses. There are no photos of the Statute of Liberty or Times Square. In most of his photos, there aren't people. This adds to the otherworldliness of his photos. The color is amazing. Most of his images contain large elements of neutrality to which the colors offer a counter point.
Here is a link to a guy who blogs about night photography. There are some links to some really good work from here.