To the extent that the ancient Greeks, who invented tragedy, were attracted to this kind of narrative, we moderns recoil from it.
Our culture adores comedy, drama (that hybrid type which Aristotle would have still considered comedy, but which since the 16th century has described all dramatic genres, rather than one type), but keeps tragedy at bay.