Night scene and fireworks scene will
increase the exposure time (to 4.0 seconds in the case of fireworks scene). That's the opposite of what I want.
I did figure out how to do it, kind of. You have to set "AE Metering" to "spot" so that the software's assessment of the amount of light is based on just a single point in the centre of the image, rather than an average of the entire image. Set exposure compensation to -2.0. You can also tinker with manually setting the sensitivity and the white balance. Then, zoom in as far as it will go (with digital zoom enabled, preferably).
This method gives the results I was looking for, except that you can't show the moon at the same time as buildings or landscape features.
Here's an example:
1/485 second, F5.6, ISO 800, EVComp -2.0
Click on the image to view it in a larger size