Night flying in a SEP is wonderful and I feel that the reward/risk ratio is still worth it, though I'm less sure about how folks on the ground might view the risk/reward ratio.
Be careful if the weather is less than perfect; wet, gusty weather can be decidely unnerving for the inexperienced. It is frighteningly easy to lose visual reference and I'd say a basic and current competence in instrument flying is a prerequisite in all but ideal conditions.
Most of my SEP night flying was back in the days when Rule 5 was interpreted a lot more liberally than it would be today and some of my most memorable flights were operating low level over London. The SVFR desk at LHR would usually clear you direct from Tower Bridge to CHT at around 1700ft and the view at night was literally stunning.
I did have cause to pause and reflect after one particularly low level clearance in a PA38 across the west end of the LHR CTZ; the landscape was particularly black and featureless, there wasn't a horizon to speak of, I was essentially on instruments the whole way, and on being spat out right on the wycombe ATZ boundary and being given the local QFE from the tower, found that I needed to climb a couple hundred feet to join the circuit.
Old age, common sense and stricter interpretation of the rules preclude such activities now, but the memories will stay with me forever.