@Commander
I think that there are lots of games that end in tragedy, and it's honestly a very common trope. Games like Brother's a Tale of Two Sons, Kingdom Hearts (most of them), Metal Gear Solid (most of them), Final Fantasy 6 and 7.
Sad or bittersweet endings, are a surprisingly good way of ending games, and while they aren't happy, they invoke a feeling of satisfaction none the less.