The Times Online has a list of the top off-target Bond moments. It's a lengthy list that doesn't even begin to scratch the surface. I re-watched Diamonds are Forever this past weekend, and man, is that a lousy piece of cinema. Daniel Craig's turn in Casino Royale indicates the producers are on track to let Bond live up to the potential the franchise always showed; but I'll wager that by the third or forth film they'll be back to ridiculous stunts and worse puns.
It's like vampire movies -- they're hardly ever any good, but I just like the concept for some reason, and every once in a while a watchable vamp flick comes along and temporarily renews my faith in the genre.
But, like all genre works, too many hacks enter the field because the tropes of the genre seem obvious enough that it shouldn't take a Hemingway to make a good zombie movie, or Western, or space opera.
Except that it does. Sue Grafton may outsell Dashiell Hammett, but no one's going to be reading her fifty years from now.
More Dullard takes on Bond here and here.