Heroism: The temp HP is extremely strong when you first get it, but that fades with time and levels.
Sleep: You can lay waste to entire encounters with this spell.
I like how you have shown with Heroism that it fades quickly. Unfortunately Sleep fades even quicker, in my opinion it is close to useless by level 3. So I would make it Purple, and mention that it starts as Sky Blue.