One of my favorite CYOA books, and one of the ones I started with, was The Cave of Time. And I will never forget that one of the threads didn’t end with a terrible death, but did end with you settling down and living happily in the past. And it ended with the words, “You die a few years before you are born.”
That still gives me chills.