Completely agree with Nightwish, but would also suggest Within Temptation. Melodic type of metal is my favourite as well. Wish I could give more suggestions.
Example of Nightwish's music (earlier years with their original singer, Tarja):
Example of Within Temptation's music: