The haunting song "Hijo de la Luna" (translates to "Son of the Moon") composed by José María Cano of the pop group Mecano, has resonated with many people across the world. It was first made famous by Mecano fronted by singer Ana Torroja, on their 1986 album. Here they are in a live performance of it in August 1987:
Since then, the song has also been covered by many folks, and some notable covers include the following:
The aptly named singer Loona had a hit in the 1990s with the song, and here she is in a smiling-faced cheerful cover of the song
Speaking of unusual covers, here is a cover by a rock/metal group named Stravaganzza whose lead singer starts out in falsetto and moves to a growl before returning to falsetto in the finale.
Here is a version by Kriemhild Siegel, with the lyrics translated into German; the singer also has her version with Spanish lyrics available on YT.
Here is a cover with lyrics in Polish (seen in the video) translated by Agata and sung by Nadia.
Here is Mario Frangoulis.
Well-known soprano Sumi Jo.
Speaking again of unusual covers, the popular male vocal quartet Forestella singing a version with Korean lyrics.
Soprano Ieva Prudnikovaitė & pianist Artūras Anusauskas of the Bel Canto Choir Vilnius.
Here is a translation of the lyrics into English:
Sarah Brightman -- Hijo de la luna - translated by Jos van Geffen
The Wikipedia page on the song summarizes the story depicted by it.