Beauty fans said the COLOR WOW Dream Coat Supernatural Spray 'made my hair feel like silk' and 'remained straight even after it rained'