Drakengard: Drakengard was made by cavia, otherwise known as the company WITHOUT happy endings at all. In the best possible ending out of 5 (the canon one thankfully), your companion that changed the main characters heart from that of a crazed lunatic ends up giving up her life to become the next seal that protects the world, and for the first time in the main characters life he sheds a tear. In the other endings? You have to kill the main characters sister, you have to KILL your same companion, you watch as all of your allies die before you're torn limb from limb by 'gods', and you get shot down by an F-16 over tokyo after saving everyone's lives. ALL OF THEM are tearjerkers.
Drakengard 2: Again, a game of many endings, but again, cavia, all of them hurt. In the main ending, your dragon who has raised the main character turns against you, and you have to listen to them cry at each other during the ENTIRE final fight as you kill him. Second ending is much the same, except your love interest becomes a vessel for the gods and you have to kill her. This game is only really tear jerking in the first ending for me, considering the love interest is the same crazed lunatic antagonist from the first game.
Nier: CAVIA! Easily the worst of the 3. In the game you play as the 'best dad in the world' award, and hell, not even the ENDINGS are the worst. First one of your party members, an effing KID, is transformed into a grotesque monster after saving your life, You end the lives of an entire city to protect yourselves, etc etc. This thread is about ENDINGS though. Well, cavia ladies and gents. Your daughter is kidnapped mid game, you find her at the end, you find out HEY YOU'RE THE BAD GUY ALL ALONG! Oh by the way your daughter just killed herself oops. Call her back! okay yay! (the world still ends because great job breaking it, hero). Second ending? You get to see how badly you screwed up the antagonist's life. third? Kill your ally because she just went super saiyan. Fourth ending? Oh. My. God. Delete all your save data to save your ally instead because EVERYONE EVEN YOUR DAUGHTER FORGETS YOU OH MY GOD ALL MY FEELS.
Metal Gear Solid 4: Everyone dies, the end. One line: "Uncle hal, when is snake coming back?"