Coming from a manufacturing environment, I can tell you this. Avoid any flux from a bottle unless you can clean it completely afterwards. Both WW and NC are corrosive and conductive, and need immediate removal. Water wash needs, well... washing and no clean needs to be cleaned with a proper flux remover. And hear this out, IPA is NOT a proper NC flux remover.
No clean needs to be activated to stay on the board, and that only happens through a reflow oven. The excess flux that you pour from a bottle can never be activated completely with the soldering iron. The core flux can.
I remember a big fiasco with one of the products we were making few years ago where a coax connector, MCX type if I remember correctly, was hand soldered using excessive NC flux then the area was cleaned with IPA. The connector was carrying 5V to supply an external active antenna. A big number of boards were failing with the same symptom, short inside the coax connector.
I was in charge with investigating what was going on. What I found was that the flux was somehow getting inside the connector and during the functional test it started the electrolysis that created an initial carbon path. Later in the field, that turned into an almost dead short.
My boss couldn’t believe my theory, he thought we were dealing with bad raw parts. I had to duplicate the fault. Using two twisted wires with stripped ends, a drop of flux between them and a 5V power supply, I had a dead short within 15 min or so. The functional test was shorter than that.
Edit: Water wash flux is amazing for assembling new boards; if all the parts are washable, I always use WW flux. I end up with super clean boards, with shiny solder, that work as they should. The NC boards never look... clean. For repairs and wires though, I always use RA flux and clean it as much as I can with IPA.