What is the best procedure for landing at my destination if I have a full electrical failure at night?
Here's an investigation report on this very sort of thing in Canada.  Note that the standard procedure to alert ATC that you have a total electrical/comms failure is to fly a left hand triangle twice with 2 minute legs, every 20 min.  If they can see your non-transponder target they will quickly get the idea, and then make allowances for whatever you do next  As with IFR comm failure procedures, you should be careful to make the &quot;next&quot; thing you do the most logical thing for the controller to expect.
If there was an operational controlled airport with lights that was the only safe place to go to get down in one piece, I would proceed there doing the triangles, then when in visual range of the tower do another triangle until I got the flashing green light from the tower. And if I didn't get the light, and I was running out of fuel, I'd just go ahead and land.
Important thing to remember in aviation is that the regulations aren't a suicide pact, and once it's life or death, you do what ya gotta do, end of story, and while you may have to do a lot of report writing, if you crossed some lines taking reasonable action to save yourself and passengers, you won't get busted for that - hopefully.
If you're stuck with no other airport to go to with lights, and your darkened destination is the only option, well, you kick yourself for being so foolish as to fail to make allowances for that eventuality (which is not really that improbable), take your chances, and hope it turns out.
Of course, it is the early 21st century, so you should have your phone with you no?  So unless you left it behind or the battery is dead, call somebody. The destination airport operator to turn the lights on.  Someone you know there that can light up the runway with a few cars.  An air traffic control unit.  911 even.