I shoot mostly landscapes and have had a variety of wide primes over the years. I currently have the 24 mm f/1.4, use it on my D800E, and really like it. Before the D800E I used it on the D3s and the D700.
I find it works well with low light although I use it with a variety of lighting situations. I am attaching one image I took at the recent ANPAT using a tripod and ISO 3200 around 6:30 in the morning at f/4 and 1.0 sec. The image was cropped to bring out the intensity of the stars.