Some of my top choices have already been mentioned, so I'll go with Natalia from Goldeneye. I find that escort missions are pretty much always a pain - look at Ashley from RE 4 for a solid example of an irritating character - but Natalia was a special kind of stupid. I can't imagine the number of times she just wandered into a firefight and got herself killed.