In nearly every circumstance, hot water (120-150F) will be better than room temperature water (70-80F) in terms of removing residues from soldering processes. While the surface tension concern that you mention is one aspect in this equation, the fact that solubility of most organic materials is better in hotter water is another strong case for going with hotter water.