Sam Sparks, once she dons her glasses and embraces her love of meteorology.
Flint Lockwood is pretty adorkable, especially when it comes to science and Sam. He's a socially awkward geek who wants to be accepted.
Milo Thatch of Atlantis The Lost Empire. 115 pounds of weapons-grade adorkable. He's so clumsy-cute, even a princess falls for him. He's voiced by Michael J. Fox, which helps. Early on, Helga lampshades it.
Flynn Rider (or Eugene Fitzherbert) is a Deadpan Snarker, Butt Monkey, gets pushed around by a hot girl half his size? An orphan who reinvented himself after his favourite literary character? That's weapons-grade adorkable right there.
Rapunzel has a bit of an overbite, she lisps when she talks at times, hides in her hair during the song "Mother Knows Best" when afraid, Genki Girl, she's overall naive, very pretty and downright adorably Moe.
"Dangit Jim, I'm an astronomer, not a doctor! Well, I am a doctor, but I'm not that kind of doctor, I have a doctorate, but it's not the same thing, you can't help people with a doctorate, you just sit there and you're useless!"
Ariel when she's human and on dry land for the first time. She takes in everything with an almost contagious amount of childish curiosity and wonderment. And who could forget the scene when she tried to comb her hair with a fork?
The Little Mermaid II: Return to the Sea features Ariel's daughter Melody, mainly due to her awkwardness as a teenager.
Flounder, the cowardly talking fish. He's cute and beautifully coloured in blue and yellow.
A Goofy Movie: Max and Roxanne, the Birds of a Feather who stutter and stammer and behave awkwardly around each other. Max is Goofy's son and this shows up in his clumsiness and laugh as well. But lineage is not the end-all be-all: Max's Fat Best Friend PJ (aka Pete's son) has a baby face, a shy and anxious personality that's even more awkward than Max's, and a voice that hasn't changed—and, as is revealed in the sequel, never did.
Megamind's Megamind, notable especially when he's disguised as Bernard and one of his most relatable, lovable traits. Just watch one scene and you'll see.
Corpse Bride: Victor Van Dort. He's extremely clumsy and socially awkward during the wedding rehearsal as he can't speak up or put a ring on Victoria's finger without embarrassing himself. Victor Van Dort? More like Victor Van Dork. However, both Victoria and Emily find him irresistible and fall for him immediately.
Bryony sometimes, like when she's getting excited about gift wrap.
The titular character Arthur is by no means elegant and worries about almost everything in a hysterical manner, but is an eternally cheery Nice Guy who wholeheartedly believes in the magic of Christmas.
The Great Mouse Detective: Could briefly be used to describe Basil after Olivia's My Parents Are Dead moment. He gets very awkward and tongue-tied before snapping back to his usual self. There's also the scene where he's awkwardly trying to cheer up Dawson. "I say...Dawson, old chap?" with a nervous smile.
Louis the little molehog from Ice Age: Continental Drift. He's a shy little hedgehog with Puppy-Dog Eyes who everyone calls a weiner.
As the above page quote suggests, Johnny from Hotel Transylvania qualifies. He's an American surfer-dude backpacker klutz who tends to ramble about random anecdotes from his travels, geeks out over the monsters (once he's through being terrified of them), is quite considerate of the feelings of others, and is a hopeless romantic.
The entire Big Hero 6 team to varying degrees, especially its leader Hiro Hamada. He's clumsy, awkward, has Messy Hair, and loves to build robots. The slight gap in his teeth only adds to his charm.