Dialga, his sanity restored, feels the lingering sorrow of one of the heroes who saved the world, and... "I GIVE YOU... THE FUTURE! THIS IS MY THANKS! PLEASE ACCEPT IT!"
The lovely heartwarming scene after the pre-game end credits when Dialga brings you back, and you reappear on the beach in the same spot your partner found you. And you and your partner reunite, then your partner can't help but drop at your feet (or cry on your shoulder)
Let's not forget how Bidoof comforts your partner... after you disappear from existence and they breakdown on the beach after remembering all the good times you had together, after you've being gone for months
The second ending (for the post-credits story) as well as when you reunite with Manaphy.
Finding out Grovyle, Celebi and even Dusknoir survived in Sky. The music really cinches it.
And the scene right before that is probably one the best in the game. Grovyle holds a tearful Celebi in his arms as the two watch the sun rise while they - and the world around them - fade into oblivion, until it comes back in a flash.
Not to mention the fact that not only Dusknoir, but also his Sableye mooks, have all pulled a Heel–Face Turn by the end.
A somewhat obscure example concerns Team Tasty, consisting of an oblivious Swellow and his Wurmple partner who is highly distressed, thinking his leader wants to eat him. Around the time of the Manaphy chapter, Wurmple is alone and wondering what to do, before deciding he should put his trust in Swellow and confront him about his concerns. They aren't seen again until right after Aegis Cave has been unlocked/explored for the first time, and they're not even in town, instead on the beach. After their conversation, there are no longer any fears about where they stand.
Swellow: What...what are you suggesting? Me? Eat you? Are you kidding? Wurmple! You're my trusted partner. You're my one...and only partner. There's no replacing you! You and me, we're going to keep on exploring together like we've always done. (Pause - Wurmple tears up) Hm? Why are you crying? Wurmple: Eep... Thank you, Swellow... You are my one and only leader. I'm very... So very h-h-happy...
"Truly bad Pokemon...don't really exist anywhere"
Even Darkrai isn't immune, as after he loses his memories he becomes nice.
At the end of Igglybuff the Prodigy, we learn where Wigglytuff got this mindset from- His master and mentor, Armaldo, was a dangerous outlaw... yet he was still a good Pokemon to him.
When the guild master says that very nice speech before the Darkrai battle.
"Bidoof's Wish". He asks Jirachi for a friend he could be a mentor to. Some time later, enter the player characters. Awww...
Not to mention when he's about to be mugged by Team Rogue, and the entire guild shows up to defend him. There's even a second (obviously, much easier) fight scene, with a remix of the Guild music playing through it.
What really completes it is a line from Chatot of all people.
Chatot: Don't you DARE pick on our apprentice!
From "Igglybuff The Prodigy". Igglybuff is screaming and crying over the arrest of his master, Armaldo, and is about to attack Magnezone and Nidoking. Armaldo himself stops him and calms him down, accepting his own arrest and giving Igglybuff the very first treasure they found together to remember him by. Also a Tear Jerker.
Plus, Armaldo stating that the past few months of exploring alongside Igglybuff have really revitalized his love for exploring. It's pretty clear that exploring isn't the only thing Igglybuff 's a prodigy at.
In Super Mystery Dungeon, there's a connection orb quest about an Igglybuff asking to deliver a Tiny Reviver Seed to an Armaldo. The Armaldo mentions that an Igglybuff asking to help him reminds him of his 'junior' and that said 'junior' is the Guildmaster at his own guild. That's right, Armaldo was eventually freed, and he met up with, or at least heard of, Wigglytuff after all those years. And to make it sweeter? Wigglytuff himself is implied to be the one you can recruit, and they can adventure together!
Chatot gets one of his own later during his Heroic Sacrifice. That, and the entire Brine Cave cutscene with him and Wigglytuff. Awww.
When you and your partner return from the future and decide to get help from the guild, all the guild members emerge and sort of gape at you in shock. Then Wigglytuff himself shows up, and what's the first thing he says?
Not to mention the chapter immediately following that scene, The Guild's Crew. Chatot laughs at your story, but then Bidoof steps up and announces that he believes you, causing the rest of the guild to do the same. And then Wigglytuff and Chatot reveal it was a Secret Test of Character for the guild, and finally, the entire guild unanimously decide to assist you at all costs. That entire segment is heartwarming on So. Many. Levels.
In that same scene, Bidoof saying you and your partner are more important than Dusknoir. Given how much Bidoof (and the rest of the guild, for that matter) admire Dusknoir...
[Partner's name] told this story as often as possible, to as many Pokemon as possible. It was a story that needed to be told. It was a story of hope for world peace. It was a story of hope for future peace.
Turning to a new recruit and having them tell you they feel safer with you.
Finding a Sky Gift and being able to give it to any of your guild members, including your partner. And when you yourself receive a Sky Gift from someone, the game says you get 'a warm fuzzy feeling' inside.
How The player breaks free of Darkrai's illusion. By realizing that their partner would never give up like they did in Darkrai's illusion. Especially since both choices lead to the player breaking free.
The moment when you, your partner and Grovyle all return from the future, in Sharpedo Bluff, when Grovyle expresses how happy he is to see you again. Sure, many people say you and Grovyle only teamed up just to save the future, but this moment really showed how much he truly cared for you.
Grovyle also refers to you as his most trusted partner and best friend. Flashbacks also reveal that you and Grovyle worked perfectly as a team. It's hard not to get a warm, fuzzy feeling whenever these details pop up.
The Manaphy your character and the partner raised leaving you two to live in the ocean is a Tear Jerker itself. But notice how Chatot looks sad himself, almost as if he understands the player and the partner's pain. And if you read Sunflora's and Bidoof's diaries you'll read that they notice how sad those two are and plan to cheer them up the next time they see them. The Wigglytuff Guild always looks out for their friends!