once upon a time in space is a tragedy because after all you did and worked for, all that you twisted and changed yourself in trying to fight for good, you still die, or your wife dies, and maybe you became something unrecognizable in the process. hood did come of it, but there's no happy ending in sight for you or those you love
ulysses dies at dawn is a tragedy because nothing, in the end, changes. ulysses gets their death, yes, but people's brains will still be harvested and the olympians are still in power for a long time yet. any change that might have been brought about by the tree in penelope's vault is locked away for good, but the city will keep churning people up for the immortality and wealth of a few.
high noon over camelot is a tragedy because there was hope, before the scorpion showed up, before the pendragons were shot dead. it's a tragedy because real change could have been made, before that battle on the camlan wastes and mordred's piloting of the station. the world dies, and one person is left alive, the sole survivor of this destruction, wounded by a son he hadn't been able to know.
the bifrost incident is a tragedy because you tried so damn hard to keep this horror from unfolding, but the best that you can do is delaying it. your sacrifice isn't quite in vain, but it at best brings the universe a few decades before that inevitable gleaming horrible demise from the incomprehensible. the best you can do is keep it at bay.
death to the mechanisms isn't a tragedy. it's something that should have happened a long time ago, and it's dragged itself over longer than it should have. it's a bit bittersweet, but you've lived your life far longer than anyone should, and it's more akin to finally releasing your breath than anything truly heartbreaking.