I don't mind a game with 'good' scripting. HL1/2 of course are the best examples. However I cannot stand games that are so heavily scripted that each playthrough is 100% identical (I'm looking at you CoD!). Worse yet, scripted sequences that take control away from the players. That just drives me NUTS.
One of the reasons I think Farcry 2 is 'meh'. Way to many times I'd love to be doing something but have to sit back and watch the action.