Oh, about the photographic memory. I’m not sure exactly where I heard it first, but my high school history teacher supported it with a personal anecdote: she once had a student who had what seemed to be a photographic memory, and would frequently answer questions on quizzes with lengthy, direct quotes from the textbook on completely irrelevant subjects.
Anyway, for whatever reason, the brain has a capacity to ignore and forget details it considers unimportant; as one Cesare Mondadori puts it, “maximal memory” and “optimal memory” are not synonymous.
In many stories, things go horribly wrong and characters hurt, badly, but in the end, things end up much better than they started. As you say later, it’s often more about the striving than the suffering. Currently, The Shawshank Redemption is sitting at the top of the IMDB Top 250 Movies list. Is that a tragic story? It does have a happy ending, after all.
Incidentally, my favorite movies to watch over and over tend to be comedies. Are Blazing Saddles, Airplane!, and Monty Python and the Holy Grail capital-G Great? How about the works of Gilbert and Sullivan? Mark Twain wrote comedies, and Don Quixote is a comedy, too!
I suspect that comedies tend to be more culture-specific than tragedies; things that were hilarious 300 years ago might just get yawns and blank stares today. On the other hand, some comedies do stand the test of time, they’re just a bit less common. Lysistrata is over 2000 years old and it hasn’t stopped being funny yet, and Don Quixote outlasted the entire genre of stories it was making fun of.