One of those dreaded alternator failure, replacement, still something wrong issue solved!

I think the melted alternator plug/harness thing is kinda common (seen a few videos of people repairing these) so I'm not sure your loose cable clamp was necessarily the root cause. I suspect I had a plug/harness problem in my 2nd gen too that intermittently caused a no-charging condition until I disabled the vvcs function that is controlled and sensed at that plug. But it's so tight to work in there I'm putting it off replacing the plug. I bought the replacement plug but am just dreading doing it. Did you drain the coolant and remove the top radiator hose and fans to do that plug splice job? And do it from the top or the side? Take any photos of your job? Would make a good DIY.

The FSM recommends to disable the vvsc as the first step in any no-charge troubleshooting by disconnecting the battery current sensor. This will tell you if your regulator is still good or not by disabling the external controls that could make it appear like your alternator isn't working. I couldn't get mine unplugged but that's how the FSM recommends to start troubleshooting to avoid misdiagnosing the alternator as bad. That looks like alot of tight and tricky work to DIY the alternator swap only to have the same problem after.....

You might try another browser if you can't get the nicoclub site to work. I can't get the manuals to work in Chrome but Edge(!?) works for me. Might just be some browser settings I've made in Chrome and never made in Edge because I never use it. Those manuals are key to figuring so much stuff out.

2ndGen, strange timing but I saw a Nissan Maxima dies while driving video today that sounds even more like your original failing alternator situation. Don't know if you've ever seen Eric O. on South Main Auto channel on youtube but he does a bunch of good diagnosis videos and this one happens to be on our exact charging system. In this video he gets a Maixma that goes into some kind of limp mode due to high charging voltage rather than the battery dying from low voltage. This one would flash the battery light sometimes. He ends up replacing the alternator and not the harness even though the Nissan dealership quoted $2000 to replace the harness. They must have been thinking it needed that plug/harness replaced too.

He cleaned up the battery connections in this one too because they looked crappy so maybe the loose battery connections had something to do with the original cause of the alternator failure after all.

Check out this video and tell me that doesn't sound like your car's behavior..... there's a part 2 where he completes the repair.