Both kinds of endings have their merits, but I just happen to enjoy happy endings more. I play games to have fun and relax, so I don't really want my last impression of a game I spent a ton of hours playing to be the epitome of sadness. (Unless the game's been really, really depressing from the intro.)