Night flying is magical, and I would have to say that flying into Melbourne at night was worth doing the whole course for, if nothing else. I try to start or finish as many flights as possible at night, because the experience is so different to day time flight. But, and it is a big but, I also have to fly at night regularly to remain current. Night flying carries a far higher risk, with a lot more potential for things to go wrong - both with the pilot and the aircraft. Ayavner's photo of Bankstown demonstrates how clearly defined the horizon is there. Even under the hood you get enough of a perception of what's around you, to not be fully without an horizon. When the view out of every window is the same as the TV turned off, it's a very different picture and feeling, and yes I've had the heart racing a couple of times as I turned onto base.
I demanded my instructor take me out on the blackest of nights as often as possible. On top of this, he insisted that I fly and land without landing or instrument lights for about 70% of the course. By comparison, flying over the cities is a cinch.
As a side issue, put your hand up if you've suffered the leans at night? I'll start. I have.