Here's what I'm currently thinking about:

Songs that are in English:

1) Cheshire Moon - "Snow White, Red Road"
http://www.youtube.com/watch?v=XzGXZlpvMmc

"The castle is on fire tonight; with no one to rescue, the prince is gone . . ."

2) Colin Devlin - "Raise the Dead"
http://www.youtube.com/watch?v=BovvI8IrMsU

"But you can't raise the dead from the ever after . . ."

3) Sharon Knight - "Fire in the Head"
http://sharonknight.bandcamp.com/album/neofolk-romantique-2

"There's some wake mad, and some wake dead, and some will rise with fire in their head."

4) Nightwish - "Planet Hell"
http://youtu.be/_q6chUtSef4

"Welcome to Hell, little saint . . . welcome to Paradise, soldier."

5) Josh Preston - "Counting Backwards"
http://youtu.be/zfzekezwZwE

"Even when man was on the moon, he couldn't wait to come home soon, so he could feel it rain."

6) Trad. (performed by Peter Bradley Adams) - "London Bridge is Falling Down"
http://youtu.be/TMEFHXHHq3Y

"But iron and steel will bend and wheel and break before the morning."


Classical/art songs:

1) "Am Donaustrande" (On the Banks of the Danube) by Johannes Brahms.
http://youtu.be/A60AoJuf4gg

Text and translation here:
http://www.recmusic.org/lieder/get_text.html?TextId=4244

2) "Svarta Rosor" (Black Roses) by Jean Sibelius
http://youtu.be/tddQXqHky7Q
(There's a link to a translation under the video.)

3) "Verrat" (Betrayal) by Johannes Brahms
http://youtu.be/7d70b8cOhKQ

Text and translation here:
http://www.recmusic.org/lieder/get_text.html?TextId=9967

4) "Der Zwerg" (The Dwarf) by Franz Schubert
http://youtu.be/VfNfUNQCNb4

Text and translation here:
http://www.recmusic.org/lieder/get_text.html?TextId=3952