Right. More.
Who can forget Earthworm Jim?
Count Bleck and his minions from Super Paper Mario (come to think of it, just about everyone from the Paper Mario games are pretty awesome).
Kid Ying and Dr. Yang (also known as Goemon and Ebisumaru) from the Mystical Ninja games.
Elvis from Perfect Dark.
Quote, Curly, Balrog, and all those other cute little sprites from Cave Story.
The sprite from Secret of Mana (Seiken Densetsu... 2? I think).
Legend of Mana characters... oh let's see. Niccolo, Daena, Bud and Lisa, Sierra and Larc, Dewell, Tipo, Sotheby and Kristie and those two fellows who work for them (gah! Can't remember names!), the Lilipeas, Watts, the list goes on. That game is awesome in pretty much all respects.
T260G from SaGa Frontier. Asellus is cool, too.
Noa from Legend of Legaia.
Meru, Haschel, and Kongol from Legend of Dragoon.
Ayla, Robo, Lucca, Frog... oh hell. Everybody from Chrono Trigger (and a lot from Chrono Cross, even though there are about 40 PC's in that game).
Rudy, Jack, Cecilia, Zed, Emma, all those folks from Wild ARMs. Apply that to the other Wild ARMs games. Those characters are all pretty well likeable.
Leon, Chisato, Ashton, Celine, Precis, and Dias from Star Ocean 2.
The friendly spiders from Exile. The dragons in those games are pretty cool, too.
Slippy. Yes, the one from Star Fox. Am I the only one who likes Slippy?
I'd list all the characters from the Final Fantasy worlds who intrigued me, but I'd be here all night. FF6 had the best cast, anyway.
Gordon Freeman. (I don't need to tell you what game that's from, do I?)
Fei, Citan, Chu Chu, Rico, Ellie, Emeralda, all those folks from Xenogears. Shion, MOMO, Jr., KOS-MOS, chaos, all those folks from Xenosaga. Except for Jin. I don't like Jin. He feels like some character they just inserted to give the game more of a Japanese flavor; totally out of place.
Oh... there was this guy. He was the first openly gay video game character I've ever seen... it was some RPG for the XBox 360... he attacked by singing and playing a saxophone or something. Don't remember his name!
XIII had a cool cast of characters, from what I remember. Don't remember anybody's name, except for The Mongoose, who I remember killing with, like, a million rounds from double mini-guns and a few dozen grenades.
Jade, Pey'j, Double H, and all those cool characters from Beyond Good and Evil. The Jamaican rhinoceroses.
That invincible old man in Legend of Zelda who tells you strange, badly translated things.
That drunken scarecrow from Conker's Bad Fur Day.
Dekar from Lufia II.
Midna from Zelda: Twilight Princess. She was just cool.
Jimbo and Sully, from Contra III, because how can you not appreciate guys who can take out a flying war machine by hanging on the missiles it's firing at them with one hand and shooting with the other?
Man... I think I could go on, but I'm out of ideas for now, so I'll stop. How's that for a limited selection, WolfoxOkamichan? HA! That'd be from me who's been playing games since he was about 3.
Nidonemo: something tells me you're not alone.