I visited the Old City tonight, with both a video camera (Canon Vixia HG20) and a point-and-shoot camera (Nikon Coolpix S210.) The Nikon has a much higher resolution, and I have taken many good pictures with it, but I had a feeling that for night shots the still mode on the video camera would give me higher quality shots, because it has a much larger lens and can gather more light.
So I took a picture of the Kotel from the same angle, using the default settings on both cameras.
Besides learning that I need to clean the lenses, the differences in quality are huge, and apparent even without enlarging the images to their full sizes. The small point-and-shoot just cannot handle low-light situations well. (Click on them to see that the Canon does well even at full resolution, while the Nikon is badly fuzzy at its higher resolution.)
For night-time photography, check out your camcorder - you might be pleasantly surprised.
Here's the Kotel from another angle on the Canon: