Before GPS Approaches became the norm, numerous airports had no navaids and therefore no letdowns. The only way to get into those airports at night was NVMC.
You went IFR as far as you could, then nominated NVFR Procedures for the last route segment! Otherwise you couldn't go below the LSALT!
I always found the NVFR more restrictive having to have an alternate within an hours flight time of the planned destination (if there is no navaid or you are not trained to use it). If you are below 5700kg you can plan to an aerodrome at night IFR without a navaid provided you have a nominated alternate. Obviously if you are above 5700kg you can't plan to an aerodrome at night that does not have a navaid.
.... unless you fly a visual approach
Yeah you can fly a visual approach at night provided you meet the planning requirements with alternates and don't leave the LSALT or MSA until the circling area (or the 3 mile zone if there is no published instrument approach)
NVFR at night in a twin is for scungy GA operators trying to skimp on airway charges.