Somewhere at the three-way intersection of the Hollywood Nerd, the Dogged Nice Guy and The Woobie, there is a character who is, quite frankly, a huge dork. He is socially awkward, not conventionally attractive, and a failure at his attempts to win the pretty girl (if he can even get a complete sentence out in her presence). And we root for him, because he's just so humble and adorable in between his flashes of brilliance. He might be capable of heroics if pushed, but he is generally not the Badass Bookworm (at least, not yet). He's smart but generally only in the hard sciences or obscure topics, giving him a possible foot in the door as a tutor to The Chick or an assistant to The Hero. Obviously, in a Five-Man Band, the lovable nerd will be The Smart Guy. Often subject to geeky turnons.
- Flynn Carsen, the title character in The Librarian series of movies. His nerdiness is a big selling point... considering he's an action hero. Who has 22 college degrees. And who's also the biggest nerd in the world. And, oh yeah... he has an adventuring partner.
- Dave Stuttler in The Sorcerer's Apprentice. He can barely talk to the girl of his dreams, but HE MAKES MUSICAL LIGHTNING! (Sometimes he even uses a Tesla coil, too.)
- Randy Meeks from Scream. Incredibly nerdy about films (especially horror films), but is overall a kind person and a loyal friend.
- Waldo Butters of The Dresden Files. It's hard not to like the little guy, what with his cheery demeanor, polka obsession, and occasional flashes of pure awesome.
- The eponymous character in Chuck — at least before he starting Taking Levels In Badass. For example, the pilot quickly establishes that he hasn't been in a relationship in a while, partly due to his conversational awkwardness driving women away. Soon after, a gorgeous woman flirtily approaches him at his job in the "Nerd Herd" (the electronics support team of a big-box retailer) right before a desperate father seeks his help because he "recorded" his daughter's dance recital footage with no tape in the camera. Chuck promptly puts the beautiful woman on hold to save the dad's bacon by setting up a spot for the little girl to re-perform and re-film her ballet routine right there in the store. Fortunately for him, the beautiful woman thinks it's lovable, too.
- Otacon in Metal Gear. When Snake first meets him, he is a computer hacker and an otaku, and so terrified by recent events (particularly an encounter with Grey Fox in which Snake intervenes) that he has wet himself. And he is definitely Captain Awkward with Naomi Hunter in MGS4.
- Dr. Horrible's Sing-Along Blog: Dr. Horrible is a lovable nerd trying to be a badass, at least at the beginning.
- Tyler from Disappointing Gay Best Friend is a nerdy bookworm type who's constantly annoyed by his friend Mikala's attempts at making him a Pet Homosexual, but if the videos' comments are to be believed, he has built up more than a few admirers.
- Most of That Guy with the Glasses are a mix between Hollywood Nerd and adorkable. Despite their penchant for Accentuate the Negative, the fanboy and fangirl inside them come out for regular super-sonic squee.
- Twilight Sparkle from My Little Pony: Friendship Is Magic. She's a Badass Bookworm who starts the series as an Ineffectual Loner. Even after she learns to socialize she's still depicted as being organized almost to a fault and as a compulsive studier whose joy for learning is absolutely adorable. In one episode, she hosts a sleepover by reading a guidebook to slumber parties with (somewhat) successful results, in another she dresses up for Nightmare Night as an obscure historical character that no one recognizes (And is surprised by this), and in another she's so scared of bruising her study grades that she actually kicks off a moderately large crisis in her town.