The cases where I find it most useful to display data with a rainbow-like color scale are where the data is in log-scale. In that case, I really want to convey the fact that there are enormous differences in the data in every small change of color.