For high voltage and through-hole, I spec (water-soluble) with a board wash even though people complain it's costly.
Otherwise, I'm always staring at flux residue that endangers creepage requirements.
It might be the CM's paste is crap, how much residue to expect I'm not sure.
Then I found no-clean flux residue conductivity is non-linear, it's not a simple resistance. It shows up on microwave and high impedance circuits (several megohm), worse with humidity. A good water or IPA wash and dry, many problems fixed, so these are my experiences.
No-clean seems fine for low cost consumer goods but the residue I always clean off after rework.