Okay, I tried to narrow it down to a best and a worst. But it was too tricky. 5 best, 5 worst.
BEST
* Always had a fondness for Carey Lowell as Pam Bouvier in Licence to Kill. While she's not particularly exotic, she's gorgeous, can act and doesn't need constant rescuing. Her relationship with Bond is also one of the more interesting in the series.
* Natayla (Izabella Scorupco) as she's exotic, beautiful and seems to get to ol' Bond unlike many of the others.
* Ursula Andress seems to get more beautiful as Honey Rider every time I see Dr No. Okay, so she's a proper damsel in distress and hopelessly naive (dragons?!) but...what an entrance!
* Sophie Marceau as Electra in TWINE. One of the best aspects of a rather dull entry. Beautiful, interesting character...and -woah- that accent!
* Luciana Paluzzi as Fiona in Thunderball also deserves a mention. 'Takes Bond for a ride' and refuses to be turned from the dark side. This girl is all bad!
WORST
* Despite being the first woman to get Bond to walk up the aisle, Kissy Suzuki (Mie Hama) from You Only Live Twice is extremely bland and given few lines and little to do. Despite being onscreen for a considerable amount of time, we don't even find out her name until the end credits!
* Denise RicharRAB was laughably bad in TWINE as Christmas Jones. The girl can't act and the character is under-developed.
* Found Teri Hatcher irritating in Tomorrow Never Dies (surprising as I was quite a fan of her's in "Lois and Clark" back in the day!). Hard to believe that this character 'got too close'.
* Brit Ekland as Mary Goodnight for the reasons you stated. A nuisance to Bond and, as in TWINE, there's the feeling that Bond enRAB up with the wrong bird.
* Worst of the lot is Tanya Roberts in A View to A Kill. A terrible actress whose constant screams of "James" in the elevator sequence is quite an annoyance. Laughably bad when she's relied on for exposistion too.