Finished Blood Omen (will mop up the remaining trophies another time) two nights ago and still thinking about it.
It's a really haunting game, the world so grim. The build up to the big last stand battle is great, poor Ottmar and the people of Willendorf. The Nemesis' Legion is terrifying.
I think the "good" ending is probably what Silicon Knights would have gone with as canon before CD took Kain from them. Kain does change towards the end, one line that sticks out is when, upon seeing a pillaged city, he says "This was once the most academic of cities, housing some of the most prestigious universities in all of Nosgoth. While I would not weep over lost tomes, I detested the sight of scars left upon the world at the hands of the Nemesis."
Their sequel would have focused on Vorador, so it'd (spoilers lol) presumably be a prequel which also leads me to think this.