Tragedy and Pleasure?
Yes, poor Freud has been ignored here a bit. I see his thought as vital, especially as the art therapy course I did was based so much on his psychodynamic theory. A lot of people are put off his thinking, based on the emphasis he places on sexuality and the idea of the Oedipus complex. I see the Oedipus complex as rather restrictive and his viewpoint can be seen as sexist.
However, the emphasis he placed on sexuality had a profound influence on culture and dealing with the repression of sexual aspects of life. It may be central to pleasure itself and it would be hard to imagine trajedy without a sexual aspect. The nature of trajedy itself may be about the way in which sexuality causes conflict and potential destruction. His philosophy, which drew upon mythology, emphasised the tension between Eros and Thanatos, the life and death drives/instincts.
Also, the whole idea of catharsis was central to his perspective on therapy. The idea was that the ventilation of emotional expression is the road to 'cure'. This was based on his work with patients. The problem which I see is that it does not always follow that ventilation of emotions and traumatic experiences will lead to a cure and the CBT therapists see him psychodynamic therapy as placing too much emphasis on the past.
The other important idea in his work is that of sublimation, especially in expression of the arts. This is particularly relevant for thinking about the pleasure of trajedy. It is possible to channel the nature of the sexual into creativity. This also was suggested in Tantric philosophy. With suffering, in general, sublimation may enable transformation on a mythic and aesthetic level, and from what I have observed in the arts therapies, this is an area for reframing human experiences.