Depends of the character, but they could go out like Tommy Monaghan or like Jack Knight.
Hitman and Starman had very different finales, both giving their heroes a definitive ending, both were perfect, even if I agree with Ennis and think Tommy could have more stories told, it was a a great way to end his story, Jack Knight ended in the perfect way.