Downfall takes place entirely at night - a stormy one to be exact - although the horror theme might not be what you're looking for? If I recall correctly, Monkey Island: The Trial and Execution of Guybrush Threepwood takes place at night too - it's quite nice revisiting the earlier locations from previous chapters and seeing them in a new light, so to speak!
