Leo Fitz and Jemma Simmons, the resident cute scientists. They're prone to geeking out about their areas of interest (tech in Fitz's case, biology in Simmons'), they're a couple of unabashedly nerdy non-action scientist surrounded by secret agents, and they have a very sweet friendship.
While in Buffy he was more of a dark aloof badass, in his own spinoff, Angel is adorkable with much humour coming from not knowing how to deal with his friends and being socially awkward.
Fred. She's sweet, cute, awkwardly rambles a lot, and is a massive science geek. She is practically the embodiment of this trope.
A.N.T. Farm: Olive Doyle. Not entirely the stereotypical dork, but she has a large brain capacity, which she fills with very advanced subjects such as physics and calculus, she finds homework and extra credit assignments fun, is the youngest person ever inducted into Mensa and has long blonde hair, and a Stalker with a Crush although it's just Angus.
Felicity in Arrow. She's a computer whiz and brilliant in general, but has a tendency to turn into a Motor Mouth when she's nervous. And generally when around Oliver, she's prone to an awful lot of accidental innuendo.
Murdock from The A-Team falls into this, mostly when he's trying out a new persona. For instance, in a Season 2 episode where the A-Team protects a cab company from being taken over by dangerous rivals, Murdock becomes a superhero called Captain Cab and even makes a cloth mask and cape for himself, all while talking to his sock puppet, Socky. Face is terribly embarrassed by his antics and B. A. wants to murder him (more so than usual), but the way Murdock goes about it is just so darn cute!
Austin & Ally: Ally Dawson is a shy, neurotic Cute Bookworm who suffers from stage fright so badly she'll wreck a television studio to get away from the camera. She has many adorkable moments particularly when she's dancing, or nervously chewing her hair. Or when she's doing her vocal warmups.
Sheldon Cooper, a man who can somehow make wearing a plaid suit almost sexy. There's something endearingly innocent in his total inability to behave like a normal human being. But there's the heart and soul of a hero under those geeky t-shirts. Later in the series, he's seen as cute and hot by his girlfriend Amy. One female student had a crush on him and thought that Penny had to be into him too.
Leonard Hofstadter. He's too geeky for words, and not too great with social interaction, but he tries, and it's adorable. He has a hard time to find a girlfriend, but there are some women seriously interested in him. Notably Dr Stephanie, Raj's sister Priya, a cute chick he met in a comic book store, and Sheldon's assistant. His big love Penny has moments when she definitely finds him irresistibly adorkable.
Howard's girlfriend and later wife Bernadette. She's a petite and cute woman, and her squeaky voice is adorably weird. We see on-screen her ex who is a dashing man, and Howard's friend develops a crush on her because she's always so nice to him. Just don't make her mad or upset Howard in front of her.
Doctor Sweets. He's a cute, young genius who goes "squee" at dead bodies.
Intern Vincent Nigel-Murrey. His tendency to enthusiastically spout off interesting but useless bits of trivia is adorkable in the extreme.
Detective Amy Santiago from Brooklyn Nine-Nine is both an incredibly cute woman and an incredibly dorky one. Just witness her various attempts to impress, compliment or generally suck up to her superior officer, Captain Holt, all of which generally end with her blurting out complete nonsense, cracking jokes which completely fall flat, falling victim to That Came Out Wrong, or just generally making herself look goofy. The rare occasions she does manage to impress Holt generally result in her punching the air or a doing very gleeful but also very physically uncoordinated happy dance, and her typical reaction to receiving a compliment is to giggle like a five-year-old. She furnishes her home in a way that makes people think she lives with her grandmother, has very dorky interests such as stationery and organising, and gets giddy whenever anyone refers to her as a Teacher's Pet. And the less said about her impression of a vulture, the better.
Willow in the early seasons where she's shy and quietly pining after Xander.
Spike, before he was turned. Human William was the sweetest poetry-writing, bespectacled Victorian mama's-boy this side of of the Industrial Revolution. His poem to Cecily... textbook adorkable. Even after he was turned, he remained a sweetie pie, which is one of many reasons which he is a fan favorite and part of why James Marsters cites him as a favorite role.
Buffy herself falls into this trope. Sure she's a mega badass Action Girl, but she can also be a socially awkward dork a lot of the time.
With her oversized glasses, genuine sweetness, and bright smiles, Sister Bernadette of Call the Midwife definitely fits.
Chuck: Chuck embodies this trope. The guy is a member of the Nerd Herd for crying out loud. He's also adorable, and very shy.
Mac Taylor, handsome head of the Crime Lab, who's a Ronald Reagan Fan Boy, has an odd collection of things in his apartment (everything from antique machinery to a Joe Namath-autographed football), has Encyclopaedic Knowledge of many subjects, seems serious most of the time but has a really nice smile when he chooses to share it with anyone. Over the course of the series had 2 serious girlfriends, but a number other women fell for him as well, including Inspector Quinn, a roller-derby chick named Polly, and Stalker with a Crush Ella McBride.
Lab Rat Adam Ross. Cute, messy-haired Techno Wizard who knows all the latest clubs and fads. Flirts with girls even while at work.
M.E. Sid Hammerback. Kinda cute in his own way, overshares about his exploits/tastes including three-somes. Twice divorced, flirted with Stella when he joined the show & with Jo when she came aboard.
Sage, Lance's girlfriend in Dark Oracle. She's a little odd-looking, and a total weirdo, bordering at times on Cloud Cuckoolander. And she's just so cute doing it.
Imogen, post Lady Macbeth plot, is an odd and eccentric thing, whose far too whimsical and energetic. Saying things like 'For Realzies' and 'I must be dreaming, somebody pinch me!' with complete earnest.
Maya is a down to earth band geek who wants to be a rock star, giving her a punky-style of dorkery that does not mesh with her age. The end result of mixing 'band geek', 'cool rock star', upbeat songs, and awkward niner.
Wesley hit this note during Season 10 as The three Tennors. Attempting to be cool but overall missing the mark by miles. Yet he tried so hard, and his trying earns him this trope.
The Dick Van Dyke Show: Rob Petrie is definitely one of these. All the clumsiness and flubbing is just so endearing because of his sweet nature that it's entirely plausible for someone like Laura Petrie (Mary Tyler Moore) to fall for him.
The Fourth Doctor (Tom Baker) is an enormous Manchild, and still the most childish Doctor so far. He does have social skills when he has to, but doesn't seem to see the point of bothering with them most of the time, and a lot of his cuteness comes from him having the wrong emotional reaction to things and his extreme, giddy Nightmare Fetishist behaviour. Word of God holds that he was played like an especially loopy nine-year-old, so his Character Tics in particular are very, very cute.
The Eighth Doctor (Paul McGann). He's often childish, easily excited, even more than Ten, and somewhat lacking in social skills to begin with. As if that wasn't enough, in the Eighth Doctor Adventures, it turns out he's interested in all kinds of geeky things (Transformers, model trains, tractors, comic books, etc.), he occasionally has No Social Skills whatsoever (he asks one of his companions what makes something a date), and he's a bit of a Malaproper too, as seen here when he's rather adorably upset about his companions habitually sending him out of the TARDIS alone to make sure it's safe. Makes this kind of sad when you find out that he was the Doctor who first experienced the Time War.
They send me out first to see what its like, like a sheep down a poisoned treacle well! Or whatever it is they send sheep into...
Eleven (Matt Smith), aka "bowties are cool!" He acts a bit like an eccentric English professor in the body of a baby-faced twentysomething. Matt Smith has stated that he based the adorkable factor of his Doctor off of his favourite Doctor, Patrick Troughton's Two.
Twelve (Peter Capaldi), while appearing more gruff and stand-offish, often hits this note as well. He fits the Absentminded Professor even better than Eleven, as he has absolutely zero social skills, which often leads to awkward situations when he attempts to be social. He also Hates Being Touched, which often leads to very uncomfortable hugging whenever he's around Clara. His outfit while more coordinated than other Doctors is odd as well.
Twelve: I was hoping for minimalism... but I think I came out with magician.
Thirteen (Jodie Whittaker) also fits this trope. Her very first scene has her breaking into a huge smile upon seeing her new face and going "Oh, brilliant!" She's goofy, highly energetic, intensely curious, and talks a mile a minute. She's also exceedingly friendly; for instance, she declares that Yaz is her friend about two minutes after meeting her, and in "The Ghost Monument", she introduces Yaz, Graham, and Ryan as her "new best friends" despite having only met them a few days ago. Her colourful outfit also looks like she raided the wardrobe of a 1980s British kids' show. In "Kerblam!", she reacts to the appearance of a Kerblam! delivery robot by jumping up and down and yelling like an overexcited child.
Several of the Doctor's companions also showcase this kind of characterisation.
Eight's companion Fitz, who's gawky, scruffy, clumsy, and surprisingly bookish. He often lives in his own little world, and despite all his attempts to seem mysterious and dangerous is really just a Nice Guy. Fitz's rather epic crush on the Doctor makes their interaction even cuter.
Rory Williams, before he becomes an epic-level badass, is very much Adorkable. Especially when he tried to fight off a vampire with a broomstick...while making lightsaber noises.
Even the Doctor's Arch-Enemy, the Master, has dipped into this trope from time to time, especially when he on two occasions is shown to genuinely enjoy watching TV shows for children, namely The Clangers and Teletubbies.
"Love & Monsters" is a Lower-Deck Episode about the members of LINDA, an In-Universe Doctor fan club. All of them are endearing and awkward, such as Bliss the odd-duck artist singing a song with Ursula, and middle-aged Mr. Skinner, who reads excerpts of the novel he's writing.
"Utopia": Chantho, the Insectoid Alien assistant of Professor Yana, is a cheerful, bubbly type with an unrequited crush on her boss. Particularly adorable is when she explains to Martha the reasons behind her Verbal Tic, leading to them both cracking up.
"Planet of the Dead": UNIT scientist Malcolm Taylor is a huge fanboy of the Doctor who is unbelievably excited to be working with his hero. He also named a unit of measurement after himself.
Doubutsu Sentai Zyuohger: Misao Mondo is awkward, always apologizes and has three settings: Keet, normal and Corner of Woe. He swings between them rapidly. When in somewhat balanced state, he is actually competent, sweet guy.
Daisy is cute and pure, and her slight lisp is terribly endearing.
Benton Fraser from Due South gets much of his charm from this. While he is conventionally handsome and quite capable of going into Action Hero mode when required, his sheer earnestness, quirkiness, and lack of familiarity with the conventions of American big-city life are important defining features of his character.
SteveUrkel from Family Matters is the ultimate nerd with his glasses, suspenders, laugh and high-pitched voice. He's extremely awkward and clumsy, and quite annoying, but you can't help but sympathize with him because of his good heart, determination and undying love for Laura.
Flashpoint: Spike is always cheerful and smiling. Loves cracking jokes. Calls his anti-bomb robot "Babycakes" and treats it like a girlfriend. Check. Check. Check.
The Fresh Prince of Bel-Air: Carlton, Will's preppy cousin. An annoying yet lovable geeky goofball, often wearing polo shirts and sweaters, and always the butt of Will's jokes because of his short stature and naivete. And he invented the hilariously dorky Carlton Dance.
Ross is a major dinosaur and science geek and swoops in with dazzling lines like "would you rather burn or freeze to death?" Sometimes it works and ladies like it, but at times he strikes out.
Chandler often wears vests and suits. He makes awkward jokes and is very insecure. He makes up for a fight with Monica by expressing his feelings for her through a dictionary definition. When she asks him how he got so cute, he says his grandfather was Swedish and his other grandfather was a tiny little bunny, which gives him bonus points in cuteness.
Monica has her moments when it comes to having eleven groups for sorting towels, ironing wrapping paper and vacuuming the vacuum cleaner. Though she's very attractive in a non-geeky, non-dorky way and is a classic beauty.
David the science guy who Phoebe dated and was crazy about. She couldn't stand Ross's obsession with science, but she loved David's lab and thought he was extremely clever and extremely cute.
Glee: This series is absolutely full of these, in part to do with its main subject matter, which is showtunes and high school.
Brittany. Her naivety over the simplest of things, believing in Santa Claus and getting excitable when he shows up in shopping malls, donating a dollhouse for all the "homeless dolls", and apparently crying over broccoli because she thought that was a tiny tree where jellybabies lived qualify for this, as well as moments where she lacks social skills around strangers. You just wanna give her a hug whenever she's crying or upset. And she also has an online talk show, and is praised for her dancing by the other glee club members.
Santana:[about Brittany] She's sweet, she's innocent... she's everything good in this miserable, stinking world.
Sam loves to do impressions of characters and actors from movies, and tries to win the affections of Quinn by speaking Na'vi language from Avatar.
Finn mixes up well-known idioms and shows signs of being Book Dumb, even being amazed that books could be rented out of a library. When he is confused or amazed about something mundane, he makes a wide-eyed confused expression like a deer caught in the headlights, and is also a clumsy dancer (he hits someone in the face once).
Santana starts being adorkable in the later seasons, once everyone realises that her Ice Queen act was more than just a facade to hide her lesbianism. Admitting to Brittany that she used to count the times that Brittany gazed over to her, becoming flustered when she spots an attractive girl ("getting panic-sweat under [her] boobs") and how angry she gets when Rachel convinces her to go and talk to her, as well as becoming really shy whenever Brittany caresses her in public.
Good Girls Revolt: Cindy, whos sweet, wears glasses, and often fumbles and stutters awkwardly.
The Good Place: Chidi is a socially awkward professor whose desire to be as ethical as possible causes him crippling anxiety, and Michael's enthusiasm for humanity and his accomplishments can also push him into this - just look at his glee over his first solo project in the first episode. This appears to be Michael's real personality even with The Reveal that he was Evil All Along; he remains nerdy in the second season, when his demonic nature is known, he's outright charmed when he's given a bunch of tat with which to enact human experiences like losing his car keys.
The Good Wife: Elsbeth Tascioni is charming in her quirky scatterbrained awesomeness.
The scatter-brained gadgeteer Graeme embodies this trope with his fascination with technology, aside from wearing Nerd Glasses and sporting bushy muttonchops.
Billy's child-like demeanor and tendency to panic when things go weird (almost Once an Episode... to say the least) also qualify.
Monroe of Grimm qualifies, especially when dealing with his attraction to Rosalee. Sure, he's also a Badass Bookworm, but that doesn't make him any less Adorkable.
The Hardy Boys/Nancy Drew Mysteries: The show tried to do this to Joe Hardy in 1st season and a bit of 2nd season, when they made him wear a nerdy plaid sweater, be heavily into forensics and fingerprints and likely to start expounding on fingerprints at the drop of a hat, and he was portrayed as a socially awkward younger brother. But then the writers realized they were up against Shaun Cassidy and gave it up as a lost cause.
Max Bergman from Hawaii Five-0 is normally pretty stiff, but will geek out over Star Trek and is one part awkward, one part incredibly sweet when interacting with Sabrina. When the team dresses up in formal wear, his suits are always a little kitsch; tie-die bowties or extremely ruffled cravats are apparently in style somewhere in his head. He's played by Masi Oka.
Heroes: Hiro Nakamura. His childlike enthusiasm about his powers and anything superhero related makes him so endearing.
Despite generally being rather reserved and stoic, not to mention a Badass Bookworm, Horatio Hornblower. has his moments in Series One. Particularly in "The Duchess and the Devil" when he attends a high-society dinner party and appears out of his social depth, or really any time he's around the Duchess and doesn't know how to take her flirting and attempts to teach him "conversation".
Ted. All Ted's friends refer to him as their resident "dorky dad". He sometimes plans to charm women with his cool architecture tools.
Marshall has quite a few geeky interests like watching Star Wars or singing songs about what he's doing. He's charming, but very few women can manifest that because he and Lily are quite a steady couple.
Ravi from iZombie is positively gleeful to discover that he's working with a zombie, and spends most of his time between fanboying over Liv's abilities, making completely inappropriate and goofy remarks at crime scenes, playing video games, and searching for a cure to zombie-ism. All while being British, snarky, and wearing lots of knit sweaters.
While Sportacus from LazyTown is conventionally attractive, well-muscled and very fitness-oriented, many fans still consider him adorkable due to his constant optimism, boyish over-excitement, hopeless naiveté and awkward English. His baby-blue eyes and cheesy grin only help the matter.
Kamen Rider Den-O: Ryotarou Nogami is softspoken, easily frightened and often the butt of cosmic jokes. This crosses into Badass Adorable as he is about as hard headed as primary riders usually are and it just takes more to get him there.
Life of Riley: Ted is a stereotypical nerd, complete with well-groomed features and spectacles. He is a frequent bully magnet and is certainly in touch with his feminine side. Any mother would love to have a little boy like him, especially one who keeps saying the weirdest things.
Yousef from Little Mosque on the Prairie is tall, handsome, and muscular. However, he becomes adorkable due to his gentleness and good-natured willingness to please everyone.
Cassie Phillips, whose first appearance saw her fumbling her way into Matlock's employ on a misunderstanding that he was going to offer her a job. She's very sweet and sympathetic and you just want to hug her because she's trying to do the right thing in spite of inexperience and though she messes up, she's a very fast learner.
Cliff Lewis, Matlock's associate in the last three seasons. He's hired by Matlock because his father, Billy, guilts Matlock into. Though a lawyer, he spends a lot of time as Matlock's investigator. Cliff also gets wrongfully accused of murder twice.
Merlin and Guinevere from Merlin. Put them in a scene together and the cuteness levels are off the charts. Merlin is humorous, light hearted, quirky and intelligent. Not to mention that he is also very clumsy, which also adds to his adorkable factor. That, and he has adorably large ears and blue eyes.
Doctor Lieberman on Monday Mornings is an attractive doctor, though not a total Hospital Hottie as most of them. When Dr. Sydney Napur "makes" him invite her for a date, she and her friend Dr. Tina Ridgeway discuss whether he's dorky or not.
Detective William Murdoch is an extremely-educated Science Hero who often sports steam-punk-ish devices as his attire. He can be endearingly awkward, which is probably a major reason why the likes of very attractive Dr. Julia Ogden and Enid Jones fall for him.
Constable George Crabtree can be very weird but he's always cute. His theories on the paranormal are extremely far-fetched but he takes them super-seriously. However, he's also surprisingly sensitive and open-minded, and he's not just a copper, but a moderately successful mystery writer, too. He's a funny Malaproper who cares for animals such as dogs, horses or cats which is very sweet. If a lady doesn't like his boss, she's almost sure to flirt with George.
Katie Andrews from No Ordinary Family. She's 30-year-old virgin and brilliant lab assistant who is socially awkward and overly yet adorably knowledgeable about superheroes.
Jess, Zooey Deschanel's title character in New Girl. She's even branded as such in promotional material for the show. She's clumsy, keeps singing and humming, dances chicken dance and she wears funny fake teeth. She's a Nice Girl and a teacher.
Jimmy Palmer. Ducky's assistant medical examiner who is a big goofball that always stick his foot in his mouth.
Ellie's husband Jake, played by the very good-looking Jamie Bamber, thanks to his glasses and his schoolgirl-like admiration of the rest of the team, especially Gibbs.
In Night and Day, Tom Brake, for the most part. Introduced to viewers by his cousin Jane with the line: "Still a virgin, Tom?", he's a sweet, sensitive boy who fits many of the traditional geeky stereotypes - social awkwardness, academic brightness, braces, and a camcorder perpetually glued to his palm. Subverted in later in the series once he loses his virginity, and turns into a bit of a player.
Crime-fighting mathematician Charlie Eppes of NUMB3RS who is a springy-haired, mild-eyed Absent-Minded Professor; perceptive, savvy, and just naive enough to be a master of Adorkable.
Once Upon a Time: Killian. In his days in the navy, though he has his moments when he doesn't understand modern references or technology. His dorky reaction to learning secondhand that Emma refers to him and her as "together". It's even more profound in "Operation Mongoose", where he's essentially his pre-pirate self, awkward nervousness and all.
The Outpost: Janzo is a cute, clumsy uber nerd who's highly intelligent and very knowledgeable of science, though he has No Social Skills (at first anyway). He attracts the attention of two different beautiful woman (the first was his sister, unfortunately, though neither knew at the time, but Janzo gets with Wren later in Season 3).
Miss Brooks' Love Interest, Oblivious to Love Mr. Boynton. Mr. Boynton takes Miss Brooks on dates to the zoo, has an avid interest in frogs, is painfully shy when it comes to romance. Mr. Boynton and Miss Brooks finally marry at the end of The MovieGrand Finale
Squeaky-voiced teenager Walter Denton, who drives Miss Brooks to school.
Plaid-shirt-wearing, skinny-tie-donning, sci-fi-loving former boy mayor/state auditor/current assistant city manager Ben Wyatt.
The main character herself, Leslie Knope, who keeps binders for her types of binders and is obsessed with waffles, news, work, and caring for her friends. One of the many reasons fans think that Ben and Leslie have such great chemistry as married Birds of a Feather
Power Rangers Jungle Fury: Fran, sweet bookworm who goes off on weird monologues about pizza and can get so excited she forgets to breath half way through. She crossed into Badass Adorable at one point of time when she succesfully gave a Death Glare to half of the team.
Power Rangers RPM: Dr. K wears fluffy bunny slippers, plays violin and is just completely clueless when it comes to social interactions. She hid a cannon in fridge and controls the ventilation systems of Ranger's base with said violin.
Power Rangers Dino Charge: Tyler is loud, easily excitable, makes puns at monsters and nicknamed his zord Rexy. He also deflected laser blasts with a shovel.
Lindsay Dole from The Practice, particularly in the early seasons. She's cute, incredibly smart and eager to tackle the world of law.
The word "Adorkable" is used verbatim in this (scroll to the last paragraph)Rizzoli & Isles recap where the author is talking about Dr. Maura Isles. And she isn't exaggerating. Maura is socially awkward but highly intelligent and beautiful, in addition to coming with a geeky adorableness that Sasha Alexander absolutely perfects.
The Sarah Jane Adventures: Luke Smith, a genetically grown child who is "younger than he looks" can wire a cell phone into a spaceship computer, and is so adorably dorky that he's the first one to be kissed within the first series. In the books based on the series, Maria even calls him adorkable.
From The Sarah Silverman Program, Laura Silverman's portrayal of herself. Nice to the point of being a little awkward, infinitely patient with her near-psychopathic sister, seems to live to help others (mostly her sister, but she's also an RN).
Saved by the Bell: Samuel "Screech" Powers is a quirky, eccentric, goofy genius. He usually wears extremely loud and mismatched clothes, loves science and is a member of the chess team.
JD is an incredibly friendly and nerdy guy who has fantasies in his head and narrates all the time in his head. It's one of the reasons his patients and friends like him so much because he's so approachable.
Like JD, Elliot is a pretty good combination of this in her early years. She was very shy, short in stature, and had a tendency to cry under pressure; but her determination to become a doctor kept her going. In the later seasons, she shows shades of this, but it's overshadowed by her confidence and neurosis.
Eliza is an understated example, as she's usually fairly sexually forward and very attractive. However, in the episode "Un-Tag my Heart", the nervous way she tries to feel out her casual sex partner to see if he wants a deeper relationship, is very cute. "Would you ever want to, like, go outsiiide, with me?" She's not nearly as confident as she seems, and her insecurity just makes her more endearing.
Henry, on the other hand, is a more traditional example, he's nerdy-cute, dresses sort of like a dandy, isn't on Facebook (but is on LinkedIn), and is very into his PR job.
JohnSimm in Sex Traffic, with his cute glasses, klutziness, stutter, and darn niceness, fits the bill perfectly.
Martin Freeman's JohnWatson, a Big Damn Hero in an oatmeal-coloured woolly jumper. Being much shorter than the dramatic and intimidating Sherlock also helps. He spends a lot of time being the most caring friend, and types with one finger from each hand.
The dramatic and intimidating Sherlock has a moment of adorkability, after John proves his complete willingness to lay down his life for him. Very unusual, and VERY sweet, and at the same time awkward since he didn't expect ANYONE to do it for him. Which definitely proves that, despite the fact that Sherlock IS rude, he's probably one of the only guys who understands John. In Series 3, Sherlock awkwardly admits admiration for his friend, in an adorable way during his best man's speech.
Jim Moriarty seems to deliberately invoke this trope; being diminutive in stature, large-eyed, and Irish (with the sing-song accent to match) definitely helps. He makes ridiculous expressions and speaks in a very soft voice... only to charmingly follow it up with a creative, chilling threat. Luckily Sherlock doesn't let Moriarty kill his friends. And in the episode "The Sign Of Three" Sherlock admits how much John means to him, in his best man's speech with those bloody-awful social skills.
Ichabod from Sleepy Hollow. He's ridiculously educated and impossibly courteous and formal, even to Yolanda from Northstar customer support, to the point that he feels obligated to thank her for her assistance by entertaining her with a story that makes her cry.
Stargate Atlantis: Fans of the show have been credited before with coining this term for Rodney McKay and the actor who plays him, David Hewlett. And he's not the first in the Stargate 'verse.
Star Trek: Discovery: Ensign Sylvia Tilly. Even when she geeks out and talks too much, it comes across as endearing rather than annoying.
Malcolm Reed of Star Trek: Enterprise. He's quiet, reserved, socially awkward and a huge weapon geek. This particularly comes to the fore when he interacts with Trip Tucker, especially in later seasons when they have developed a proper friendship.
Cousin Greg on Succession is goofy and good-natured, and often wins people over due to his naiveté and odd demeanor.
Cody Martin is endearingly dorky and awkward, as well as incredibly sweet and sensitive, so he naturally qualifies...until the second season of the sequel series, wherein he Took a Level in Jerkass.
Bailey Pickett from The Suite Life On Deck sequel series. Her naivete from her Country Mouse background combined with her enthusiasm, cheerfulness, and unabashed nerdiness make her adorably dorky.
Supergirl: Kara is acknowledged to be adorkable in universe by Cat Grant. She giggles and adjusts her glasses every time she gets nervous, and gets excited about things as simple as takeout and TV with her sister.
When Nia Nal is first introduced, she's acknowledged in-universe as being very much like Kara, Motor Mouth, klutzy nature, and all. Later, she turns out to be a Pop-Cultured Badass as well, and makes puns about her powers with a totally straight face.
Supernatural: Dean pretends to be all macho but the way he gets so completely overexcited about movies and LARPing and even mini golf places him firmly in this category — he's a cute dork.
Teen Wolf: In a sea of stoic, badass supernatural creatures Stiles Stilinski is an nerdy, hyperactive blabbermouth, geeks out about werewolf mythology, is hopelessly awkward with girls and has a tendency to fall over his own limbs at the slightest provocation. There's also a Running Gag of his frustration at everyone else's lack of Star Wars knowledge and he's declared himself both Scott'sYoda and Robin.
Alan in Two and a Half Men, specially in earlier seasons: While still "mourning" over his divorce, he often gets pretty much excited if something interesting happens.
Uchu Sentai Kyuranger: Stinger is usually stoic badass bordering on Comically Serious. End of Space 21 has him apologize for his Roaring Rampage of Revenge, which is an immensely awkward scene as he fumbles through it in stark contrast to his usual confident behavior. Also, it reveals he created plushies of the team to cheer up a friend he acknowledged only recently. Others even note that he has a cute side.
Ultraman Mebius: Mirai Hibino. He's extremely, extremely gentle, kindhearted, and sincere towards people (especially his friends), but also very naive to hilarious levels. The fact that he's literally Ultraman Mebius in a human form makes him even more endearing.
Queen Victoria in Victoria. On numerous occasions she acts basically like a 19th century equivalent of a nerd. She's unable to grasp euphemisms for a woman still being a virgin, much to the amusement of those around her. Then there are her repeated attempts at visiting people incognito which fool no one (and is repeated enough to qualify as a running joke). She seeks out advice on contraception, only to be given an old wive's tale involving jumping up and down ten times. The visual of her doing so became one of the show's major promotional images.
Justin is a studious, intelligent nerd, has nerdy hobbies and likes comics and action figures. He desperately tries to look cool in front of girls, but what make them like him are usually his nerdy traits.
Justin's friend Zeke. He's nerdy, easygoing, kind of a Cloudcuckoolander and passionate about robots. He is also part of an "alien language" club and he and Justin often speak "alien" to each other.
Zeke's girlfriend Harper Finkle. She's cheerful, dorky, kind, a bit naive and known for her outrageous (and often ridiculous) fashion sense.
The Young Ones has Neil: Unlike his roomies, he does want to study and he's totally gentle.