I always liked Anju from Legend of Zelda: Majora's Mask. She's just very sweet and devoted and, I guess, "proper." Her habit of constantly apologizing is pretty endearing, as well. I ought to replay that game some day.
Getting a bit more obscure is Amir from the manga Otoyomegatari. Skilled, intelligent, capable, hard-working, devoted, and some lucky kid gets to be her fiance... I've never been so jealous of a 12 year old.
Just started watching Lost Girl on Netflix and am completely turned on over the idea of Bo, the succubus. Powerful, sexy, sensual, and pansexual. No shame in her pleasure.
I've always had a thing for Jasmine from the animated Alladin movie. Love dark skinned, straight hair women with tiny waists and killer breasts.
Of course there's always the chick from Harry Potter, but that's more of an Emma Watson thing. Same goes for most of the characters in the Teen Disney and Teen Nick shows my kids watch!
I don't even know where to start. Hermione, from Harry potter. Pretty much anyone from Doctor Who. Sarah Walker from Chuck. Daphnie and Velma. I have lots more, I just can't think of them lol
Roller Girl from "Boogie Nights" (Heather Graham). I watched it the other night for the millionth time. When she said "Are we gonna fuck?" then stripped and skated over to "Dirk Diggler" and mounted him.....CHRIST!
Comics--Elektra is first, followed closely by Storm
Cartoons--Francine Smith (American Dad), Pam, Cheryl and Lana (Archer)
Video games--Ivy Valentine and Shura from Soulcalibur IV, Leilana and Morrigan from Dragon Age Origins, Isabela from Dragon Age 2, Serana and Sapphire from Skyrim.
TV--Here it gets more complicated because it is difficult to separate the character from the actress. I love Joan on Madmen, but is it really Joan or is it Christina Hendricks? I know I loved her in Firefly, especially when she was playing the innocent seductress role, more so than when she reverted to her true, evil personality.
Dana Scully from X-files, especially whenever she had her gun drawn.
Lois is the only excuse to watch Family Guy. Even though I know better, I keep hoping for an episode where she'll rip her blouse off and go fully frontal - preferably not with Peter. Her sexual personna is dynamite!