How is Dark Messiah connected to Heroes of Might and Magic?

No, he died on his own. After talking with Faidan, he said that he could now rest in peace and was going to join Silanna. That's also quite something! He left the poet with a country that had fallen apart because of the war!