At the end of the day, Cain got herself shot dead, Adama got to see a new world, a new home for mankind.
Adama would be dead too if it wasn't for constant divine intervention in the guise of citizens in his fleet constantly experiencing visions, having God-messengers in their heads which gave them the word of the almighty, and Starbuck being resurrected as an angel with the knowledge of what to do in order to get to Earth.
Cain had none of this and had to make the tough choices. If God hadn't for some entirely unexplained reason decided to bombard the Galactica with riddles, visions and resurrections then they'd be as dead as Cain. All of them.