My question is:
Does anybody know from which works the operas in Heroes II and its expansion (there are different soundtracks for original and expansion) do come from? And I also have been trying to get the lyrics for a long time but failed
What I managed to find out is that in PoL the barbarian and warlock theme are both from Ein deutsches Requiem by Johannes Brahms.
The lyrics are taken from the bible:
for the barbarian andWo ist dein Sieg?
Wo ist dein Stachel?
Wo ist dein Sieg?
Wo ist dein Sieg?
Der Tod ist verschlungen in den Sieg.
Tod, wo ist dein Stachel?
Hölle, wo ist dein Sieg?
for the warlock.Denn es wird die Posaune schallen
Und die Toten werden auferstehen
Unverweslich
Und wir werden verwandelt werden
A translation of the requiem along with references to the bible verses can be found here.
With this information, maybe someone can find out more about the other themes.
The operas can be found on the Heroes-II-CD and PoL-CD, respectively, as regular audio tracks; the Gold Edition contains the tracks from the original. There is also a Russian website where you could download the tracks from the original as mp3-files but I cannot find that one anymore. Maybe someone got a link?
Edit: I found the site again: http://heroes.net.ru/heroes2/!