At what point should the story end?

This is a question the constantly crosses my mind for both television and comics. When should you just leave the characters alone and go to something new? Is it better to end Captain America or constantly change up the status quo for example, it is a tough call.