What, no love yet for Major Samantha Carter?
Dana Whitaker from Sportsnight.
Daenerys Targaryen.
Rita Fiore from the Spenser books (what, you think I’d suggest Susan Silverman?).
Ellie Dunn from Heartbreak House. Not specifically the Amy Irving version, but she’d do.
Lucy Warfield from Superman IV (what an awful movie, though).
Bear in mind here that her only previous male lover was Khal Drogo… that’s some might big, err, shoes you have to fill there.
I was thinking about it, and of the female characters from ASoIaF, most are either:
(a) still children (Arya and Sansa)
(b) disturbing (Lysa Arryn (sp?), the red prophet woman)
(c) evil (Cersei)
(d) intimidating as all hell (Daenerys)
or
(e) too motherly, plus also disturbing (Catelyn)
Theon’s sister, whose name I’ve forgotten, however, is quite an attractive number.
But speaking of fantasy, I vote for Molly from the Assassin books by Robin Hobb. Her relationship with Fitz just gets me far more than just about any other one I’ve read.
Oh, and while we’re tempting death, I vote for Mandy, the hot frequently-naked lesbian assassin from 24. (Assuming that she’s putting aside her sexuality and seducing me in order to gain access to classified information that I have, or something. I’m guessing she’d succeed 
)
Legolas (something about the pointy ears…)
Aragorn (oh yeah, buddy. all sweaty and yummy)
Rick O’Connell (Brenden Fraser is just too cute)
Westly (from The Princess Bride)
Severus Snape (played by Alan Rickman, naturally)
Remus Lupin (oooh, a werewolf…)
Draco (fast forward about 7 years. Tom Felton is a cutie now but he’ll be gorgeous when he gets older
Rhett Butler (don’t know what it is, but I’d pounce on him)
Mr. Big (from Sex and the City)
That list should give me good dreams tonight. 
Agent Michael Vaughn from Alias
Josh from Clueless
Lloyd Dobler from Say Anything
and Special Agent Dale Cooper from Twin Peaks
I seem to have a bit of a thing for fictional federal agents.
Major Richard Sharpe, as played by Sean Bean