The entire relationship Link and Zelda have in this game:
After winning the bird-riding contest, Link is flying back toward Skyloft when Zelda excitedly jumps out into the clouds. Link hurriedly swoops in to catch her, after which Zelda nonchalantly says that she's fine. It's a relatively minor scene, but it does a whole lot to flesh out the cute relationship that Link and Zelda have.
Back to that Zelda-jump scene: Someone considered it to be cut for the purposes of data space. Everyone else decided to cut something else instead. Even the dev team thinks it's adorable!
And it also shows how much trust they have. Because think about it: Zelda leaps off of Skyloft - an island high, high in the sky, a fall that would surely kill her if she didn't call for her Loftwing - and fully trusts Link to catch her! She's not scared or worried, she just jumps and knows Link won't let her fall! And when he does, she just says she's fine when she sees how worried he looks! THAT'S some serious trust they have!
Going with the trust thing, it's also apparent whenever Zelda pushes Link off of high platforms, he's not mad, she only does it when she knows he has a safe way of landing/not falling and when her doing so does have a negative consequence, she will apologize! Again, that is some serious trust!
Zelda is very adorable in this game! Heck, even Ghirahim called her adorable!
And Link's reaction to the news that Zelda is about to wake up. The poor guy has spent the entire game worrying about his best friend (and perhaps more), has seen her enter an thousands-of-years-long slumber (which did not go over well with him) - and now he finally, FINALLY gets to be with her again, knowing that she's okay. His expression just sells it.
Link and Zelda finally being together for the first time after she awakens from her thousand year sleep. ...It's subverted, however, when a total Mood Whiplash occurs and Ghirahim captures her.
The Ship Tease between these two in this game is just ridiculous. They're best friends, Link does whatever it takes to save Zelda, he does NOT appreciate Ghirahim harming or attempting to harm Zelda, his Death Glare's are usually directed at him, they trust each other without question and would do anything for each other! And it also helps that in this game, they know each other. In games like Twilight Princess and Ocarina of Time, they didn't know each other enough to really be anything more than friends, acquaintances or allies. And in games like Wind Waker, Phantom Hourglass and Spirit Tracks, they're too young! But in this game, they're childhood friends and aren't too young! Make of THAT what you will!
Link's expressions in this game just make him so darn adorable. When Link listens to the various parts of the Song of the Hero, he looks so genuinely peaceful, which he probably hasn't felt much throughout the game.
What does Link do when his archrival Groose tails Link to the Surface and interrogates him for where they are and where Zelda is? He gives him a sympathetic pat on the arm, smiles at him, and gives him the scoop.
This game makes it so you'll do something special for at least one person no matter what you do. For example, Peatrice (the Item Check girl) gets absolutely no business at all... and then Link comes around. The more you go to the Item Check booth (and you will have to go there often to swap out or sell stuff), the happier Peatrice gets, and the more she starts crushing on Link.
This is especially nice for those who are sick of the Ship Tease between Link and Zelda in their many different incarnations, and this gives gamers a chance to give Link a female companion who is upfront with him.
Fi wishing Link good luck before the battle with Demise. Considering how mechanical and impersonal she typically acts, it's very touching to hear her finally encourage him in that way.
Fi's final words to Link before going to sleep forever and becoming one with the Master Sword is that she'll meet Link in a next life. She does. All Links share the same spirit, so every time another Link picks up the Master Sword, whether they know it or not, they are meeting again. So in a way, it really isn't goodbye forever when they part ways at the end.
After the creditswe cut to a bunch of the villagers at the now earthbound Goddess Statue. Zelda says to Link that she wants to stay on the land the rest of her life, and Link doesn't even bother to answer with anything but a nod and a smile, implying he's going to stay with her. The way it's shot with the Triforce in the background and Zelda's white dress makes it look like an exchanging of vows.
Groose. When you leave him he's having a meltdown over being unable to do anything while Link takes on the Big Bad. The next time you come back he's not only gotten over his funk, but built an entire rail system to combat The Imprisoned. Talk about Character Development!
Going hand-in-hand with that is right at the end, when Groose travels back in time after Link to see what he can do to help, and managing to dive and catch Zelda's body after Demise tosses it aside. The simple fact that the player will think "Hell yeah, Groose!" about a guy who was the resident Jerk Ass at the start of the game speaks volumes about how far he'd come.
Pretty much the whole relationship between Groose and Link. In the beginning, Groose locks up Link's Loftwing, and basically just shows that they're rivals. After Groose follows Link to the surface, eventually, he warms up to him and thinks of him as a friend, helping him out against the Imprisoned.
Compare the colour of Epona in other games to the colour of Link's Loftwing, apparently so rare it was thought to have vanished from the line. Perhaps Fi's not the only one who's been sticking around with Link.
From the Bazaar there's Bertie's idle animation. His kid he's carrying on his back starts crying, so he pulls a silly face and makes a bunch of goofy sounds until the baby is laughing happily. It's a very small but sweet moment.
There's also another small moment when you say to Gondo that you believe his grandfather's stories about the Ancient Robots. After ages of being teased about believing his grandfather the guy is thrilled when someone doesn't make fun of him and actually agrees with him.
The Love Letter sidequest can end in either Pipit and Karane getting together, which is adorable. Or it can end with the ghostly hand caressing a sleeping Cawlin. It's weirdly cute, but hilarious.
The Mogmas in general. When they hear about Link trying to save Zelda they'll give him useful items such as Digging Mitts or, in Ledd's case, his own Bomb Bag, to help Link on his journey and/or will give him encouragement and hope that he finds her alright. The Kikwi also do this to a slightly lesser degree.
When Zelda is revealed to be the goddess reincarnated, and has to enter a slumber to protect herself and to maintain the seal on The Imprisoned/Demise, she asks Link to wake her up when he has collected the Plot Coupons, as she always woke him up when they were kids. Most dialogue trees have a "no" option, but all the choices here are "Of course!" "I promise." and "I will." This also doubles as a full-on Tear Jerker.
When Link frees his Loftwing after it's been kidnapped by Groose. The way it spreads its wings and opens its mouth, as if to say "I'm free!" and the affectionate, gentle way it nuzzles Link are quite heartwarming, especially given their special connection and the fact that they grew up together.
When you first see the trapped bird, the poor thing is freaking out. The moment Link steps into its sight, it calms down. The very moment the bird sees its owner, it knows it's going to be okay.
An adorable callback to that scene: there's a Gratitude Crystal in that place at night.
The Gratitude Crystals in general make for a lot of these. Miniquests aside, there is one in Zelda's room, like special, personal thanks to you.
Groose's lackeys, Cawlin and Strich, don't seem to care that Groose goes missing from Skyloft and seemingly never returns. Cawlin mocks Groose behind his back and Strich is more interested in secretly hoarding insects. But then they come down to the Sealed Grounds with Gaepora after the credits to see Groose before leaving with him. Aww, they really are friends.
There's something very gratifying about Beedle thanking you for completing his side quest, and hearing his trademark thankful voice clip used with sincerity.
At the bird-riding contest, they announce that it is the 25th anniversary of the contest. Given that this was the 25th anniversary game, there was much squeezing.
Kukiel, the sweet little girl who befriends Batreaux, is utterly precious in her innocence. She even encourages Link to collect all the "grabitude crackles" for her "Uncle Bats."
The long ending cutscene before the credits roll has a subtle example shortly after Link, Zelda, and Groose return to the present. There's a shot of the Master Sword in its pedestal, right where Link left it in the past. The doors behind it then open on their own, reminding us that just beyond was the room where Zelda had been sleeping. So in a sense, the sword (and Fi, in a sense) were watching over her almost the entire time.