Aloha: Allison briefly seems to be tough and hard-edged at first, but she later proves herself to be extremely awkward, nerdy, and idealistic, with a belief in the spiritual and a fascination for everything related to space, a direct contrast to the more cynical and world-weary Brian. She also develops a rather adorable romantic relationship with him after they fall in love.
Amélie: Amelie and Nino are quietoddballs that are kind but have a hard time making friends.
In Back to the Future, George McFly is a scrawny, spineless nerd who takes notes on what to say to the girl he likes, and then gets the words wrong ("Lorraine, my density has popped me to you!" "... What?").
Ball of Fire: Bertram is a socially awkward English professor who treats learning new slang as his life's calling and adorably fumbles about when he's around Sugarpuss. He deals with his attraction to her by washing his neck with cold water and is so flustered when she kisses him that he runs out of the room.
Bedazzled (2000): Elliot is adorkable, at least at first. Although it's rather negative in that he has no friends and his co-workers actively avoid him because of it, this movie needs a diabetes warning.
Major Hank Marshall in Blue Sky: a nuclear physicist who wears glasses, can't dance, is extremely socially awkward, and plays the clarinet (canonically because he was a band geek at school). He's idealistic, supportive and affectionate, and at one point makes a pun and then announces that he made a pun.
Bringing Up Baby: The hero is a young, handsome, yet nerdy and somewhat ditzy scientists — an irresistible combination for the female lead.
Casper: Bill Pullman as Dr. James Harvey. Seriously, the guy wears glasses, multiple nerdy sweaters and makes several attempts to be a stern father towards Kat - all of which fail.
Don't Think Twice: Most of the characters, although deconstructed with Miles whose dorkiness combined with his age and habit of picking up younger women from the classes he teaches demonstrates an outright lack of maturity.
In The Duff, when he's not falling into his jock persona, Wes is this: his childlike enthusiasm for the dumbest things, his penchant for crude humour, and his surprising love of certain things nerdy (like Bianca's "monster voice") make him oddly endearing.
Eddie the Eagle: Eddie "The Eagle" Edwards. He's an enormous klutz, wears glasses, drinks milk, and ultimately manages to achieve his dream of becoming an Olympic athlete.
The Fly (1986): Seth Brundle (played by Jeff Goldblum, who has played characters of this stripe on several occasions) is one of the more nuanced and darker takes on this trope. He's a genius scientist, not so good at talking to women. As he enters a relationship with a beautiful reporter, it turns out that his sweet awkwardness is accompanied by severe insecurity; when he mistakenly believes she is still carrying on a relationship with an ex-lover, jealousy overtakes him. He gets drunk and in his compromised mental state decides to jump ahead to the finale of his experiments in teleportation and teleport himself. This turns out to be a Tragic Mistake — there's a fly in the telepod with him, and he ends up genetically fused with it, resulting in a Slow Transformation into a gruesome mutant undergoing a Split-Personality Takeover. An early sign that something is wrong with him is that he loses his adorkable nature and becomes agressive and quick to anger; once he realizes what's actually happening his sweeter self returns, but only for a while.
Griff the Invisible is probably the shyest, meekest, sweetest wannabe-superhero you will ever meet, and fulfils this trope to the point that you almost need a teddy bear while watching so you'll have something to huggle when he's sad. Also his love interest/self-appointed sidekick Melody, a klutzy but very sincere girl with no comprehension of social norms and a lot of strange psuedo-scientific theories. Watching them dash around playing superhero is cute to a possibly lethal degree.
In The Freshman, he plays a cluelessly uncool yet ultimately charming college newbie.
In Girl Shy, he visibly stutters in the presence of a pretty woman.
Hellboy (2004): Abe Sapien was always the smart one of the group, but it wasn't until the sequel he became full-on adorkable. It might have something to do with gaining his first love interest (any time he interacts with her is stuffed full of awkward), but even before that he can be seen geeking out over some rare Victorian goggles. Fangirls are split somewhat between this portrayal and the more traditionally Badass character in the comics.
The Hobbit: Martin Freeman plays Bilbo Baggins as this. He was also pretty adorkable in the original novel, what with his fondness for flowers, maps, and calligraphy and a Cowardly Lion personality that manages to combine bumbling with Guile Hero cleverness. In the film, he faints at Bofur's description of death by dragonfire, mutters nervously to himself a lot, is very nervous about (and mildly allergic to) horses, and he's a Motor Mouth with a tendency to stutter and funny physical mannerisms.
The Imitation Game: Some of Alan's scenes with Joan are geeky, slightly awkward and utterly endearing. For instance, they have lunch together outside in what appears to be a picnic date, but they are solving complex mathematical equations. Alan later steals encrypted messages from Bletchley Park, throws little rocks at Joan's window as if he were a would-be suitor, and then sneaks into her room past visiting hours to see if they can find a pattern that can help them break the Enigma code. When Clarke's parents pressure her to quit her job to get married, Turing proposes to Joan on the spot despite not being fully dressed (his shirt is untucked while his suspenders are loose) and there is still a little bit of shaving cream on his face; he then creates a makeshift engagement ring from a string that he finds in his pocket.
In Irreconcilable Differences, Albert and Lucy are both this when they first meet. As time passes, Albert becomes increasingly cold and slick and Lucy turns into a self-absorbed diva, but by the end of the movie, some of their old personality traits appear to be returning.
Kickass: Chris D'Amico/Red Mist could be a villainous example, given his love of comic books, his slight lisp and the fact that he and Dave have a silly bonding moment jamming in Chris's car while on the way to a crime scene. Unfortunately, his lovable dorkiness disappears pretty quickly afterwards.
Samwise Gamgee from The Lord of the Rings, a sweet-natured gardener too shy to talk to the girl he likes (until the last film.)
Madame Curie: Pierre Curie the genius physicist. He is socially awkward, and nearly flees in terror when he sees his professor's dinner invitation is actually an invitation to a large party. When he asks Marie (his future bride Marie Curie) out on a drive into the country, he stammers and twists the hat in his hands.
The Martian: Both Mark Watney and Mindy Park are this on steroids.
In The Mask, Stanley Ipkiss was most definitely this before he took a level in badass near the end. Because even after he found the mask, he'd still be reduced to a shy, soft spoken sweetheart whenever he was around Love Interest Tina. The Mask is also this as he can be very strong toward Tina and can be wild as well with him being somewhat sleazy towards Tina but he cares and loves her very much and he is very adorable when he's around her as he pops his eyes out and also puts his jaws down at the same time and turn his head into that of a cartoon wolf which he bangs his head with his hammer a few times to get his head back to normal and very sweet towards her even making a heart with an arrow through it which is made out of smoke.
The Miracle Woman: In true Frank Capra spirit, our leading man does ventriloquism and gets pretty nervous around his crush, Florence Fallon.
Sir Galahad the Pure/Chaste. Zoot and other ladies from Castle Antrax find him irresistible. Unfortunately, they scare him off by being too advancing (they even ask him to spank them). When he seems like he might get into the mood, he's "saved" by one of his friends.
Sir Robin the Not-Quite-So-Brave-As-Sir-Lancelot. How else do you explain that his favourite minstrels and his group still followed him, even though when he ran away from the danger instead of fighting?
Herman and Lily were already this in the original show, but the film takes it up to 10 inThe Munsters. Lily fangirls over Herman's band, wheres his band shirt with her frilly undergarments, squees over a baby sewer monster, and enjoys dancing to electrop. More obvious with Herman (like in the series), where he's incredibly naive, shouts in joy over landing a date with Lily, performs vaudeville, and cries over getting a small arm tattoo like a child (in spite of his size and strength).
Deb makes gawky door-to-door sales pitches and cries easily from it, which draws Napoleon's...well, some sort of interest.
Pedro is a Fish out of Water exchange student who tries to become popular mainly by being a Nice Guy
Kip - Computer geek - hours of online chatting a day, socially awkward, stereotypically nerdy looks. Sings an ode to technology. Attractive to La Fawn Duh.
A New Leaf: Elaine May's character. Not only is she socially awkward, but she also forgets to take price tags off her clothes; spills multiple cups of tea in one sitting; has to be vacuumed after she eats; doesn't know how to put on a nightgown ("You've got your head in the arm hole") ... and she's a botanist.
Now You See Me: Detective Alma Dray, when it comes to magic. She looks delighted after pulling off a card trick and claps enthusiastically during the Horsemen's show.
Once I Was a Beehive: Phoebe. This girl is obviously sweet and cute, but have too much of fears of everything and she's very shy and socially awkward sometimes. She's so afraid of go to camp that when her 'leader' want talk about this, she's almost cried until Lane agree to go with her. After that, she immediately go packing.
Stig-Helmer Olsson from the Swedish {{Sällskapsresan}} movie series is this almost to the point of parody. Gangly and awkward, with thick and unfashionable glasses, neat hair and a thin moustache; retreating, softspoken and shy, and topped off with a genuine nice-guy personality that has people asking "Is this guy for real?". Also wears outdated fashion, drives a Messerschmitt, has an overbearing mother, and loves trains (models and real ones). Nonetheless, each movie has one girl falling for him, presumably due to this exact trope.
Tom Holland dials it up in the MCU [1][2][3][4][5][6] and the actor himself manifests the trope in interviews and behind the scenes [7].
Many, many characters played by Leslie Howard qualify, but honorable mention goes to Atterbury Dodd in the 1937 screwball comedyStand-In. The glasses, the pristine suit, the obsession with mathematics, the awkward fumbling around his love interest Miss Plum....
Stargate: James Spader as Dr. Daniel Jackson. He looks cute and vulnerable, and he's a geeky and quirky linguist, specializing in ancient languages. And he wears round glasses and looks like John Lennon.
Chekov, the ship's seventeen-year-old Russian whiz-kid who speaks with a funny accent, gets over-excited and runs in the most adorkable way possible. In the sequel, he gains super adorkable goggles.
"I ken do zat!"
Spock definitely has his moments, especially when he's around his girlfriend, Uhura. Helps that he doesn't seem to comprehend human sense of humour.
Uhura: Are you sure you don't want me to go instead? Spock: That would be highly illogical as I am already outfitted- Uhura Spock, I was kidding. Spock: Uh... [looks adorkably confused as Uhura kisses his helmet]
In Teenage Mutant Ninja Turtles (2014), there are a few times when the turtles really do act like teenagers, treating their own exploits like kids would. A particularly funny moment has the group in an elevator right before the climax and they all start beatboxing and using their weapons as instruments in turn, including Raph and Leo. Another funny moment had Donatello wonder if his telescoping staff had the punch to flip a humvee, and as it does so in slow motion the camera lingers on his glee-filled face.
Doug is a hall monitor who is into video games and karate, enjoys reciting Little Known Facts, tries to sneak into the popular party, and is said to have once locked braces with his girlfriend while they were kissing.
Pam may be a Girl Posse mean girl in 1987, but even before she begins taking a level in kindness, she has some adorable moments of giddily crushing over Blake and being a Closet Geek who is worried about whether robots will take over the world one day like in the movies.
Warm Bodies: R. He has a bit of trouble communicating with his love interest, being a shambling corpse and all.
What We Do in the Shadows: Viago, despite being a decidedly non-vegetarian vampire, utterly fails at being a seductively menacing creature of the night. His fussiness, Fang Induced Lisp, and quasi-maternal care for his vampire flatmates are quite endearing.
Wonder Woman (2017): Etta has an almost fangirl-like fondness for Wonder Woman starting with her first impression.
X2: X-Men United: Nightcrawler loves to give (often interrupted) long-winded introduction speeches, playfully spies on secret meetings, and awkwardly flirts with Storm.
Charles Xavier was a cute geek during his childhood, as demonstrated by the framed pictures of his favourite scientists next to his bed. As an adult, he uses his nerdy knowledge to woo girls at bars.
Hank McCoy. Soft spoken, stutters, asks Raven Darkholme out on the pretext of getting a blood sample and then apologizes for being forward.
Deadpool (2016): Colossus' first couple scenes have him eating cereal out of a bowl at least three sizes too small for him and lecturing his ward on the importance of eating breakfast in the morning. Near the end of the film, he catches a ride with Deadpool in Dopinder's cab—he's squished in the backseat next to Negasonic Teenage Warhead, and he's casually sipping a drink from a cup that's probably normal-sized, but comically small in his giant hands.
.