^
I recall a random video I watched. Guy ran a special effect studio. It's a well viewed video, like maybe in the millions. They use plumber's flux (zinc chloride, water soluble) on stranded copper wire, and they clean with water. This is their ironclad protocol, developed over many years and strictly adhered to, working with pyrotechnics and explosives and hundreds of people coordinated for 10 seconds of filming where the thing better work when it's supposed to.
For probably the first 2 years after I fell down this grand rabbit hole, I used plumber's flux from the hardware store on all kind of circuits. Along with my Radio Shack fire brand. The only issue I ever had was with steel. When the flux contacts any kind of steel, it doesn't matter if it is stainless or not. The steel will start to corrode, later, despite thorough washing... eventually causing joint failure to something like a battery terminal. Now there is a tiny bit of steel in most smd component leads, but I never had any issue with anything but actual steel like in battery terminals or or spring contacts or the like. I still have some of the PCB's and breadboarded stuff I made from back then, and they're completely fine.
From my own experience, I'm pretty sure is the chloride/halide part of the water soluble flux that causes the rusting of steel. The halide salts embed in the surface of the steel and can't be washed away with water, despite they're water soluble. This is why if you use HCl to derust a part, it will usually rerust within a few days, despite you slather the steel or cast iron with oil or wax, after washing. HCl is fast and cheap and is used for removing rust/scale, but often you want to follow HCl bath with another type of halide-free acid to remove the halides in the surface layer. For this reason, plumber's or acid flux is not kind to soldering iron tips, either.
That said, +1 on rosin flux.
I also agree that for a hobbyist, it is best to use a no-clean flux.
Not correcting you. Just clarifying for the OP. Most no cleans will be fine for hobbyist pcb work and the like. But to be clear, if rosin weren't made from trees (if rosin flux were synthetic but worked exactly the same way), it would be classified as a no clean, too. So while some no clean fluxes are exactly the same as rosin flux as far as anyone here would be concerned, some no cleans are not.