Summary: Maybe I had too high of expectations for this game. I really wanted it to be fun and for the first mission it was. I could sneak around, take out enemies either while targeting them or shooting blindly. I could.... no that's about all I could do. Yeah, once I realized that the game never got more complicated than that, I started losing interest fast.
Summary: I haven't played a Bond game since Nightfire, which, in spite of its problems, was a decent game, though hardly a standout. I had hoped that in the intervening years, the Bond series might have come up with better gameplay. Which it did, sort of. The cover system is interesting. The first couple of levels, I didn't quite "get" it and died entirely too often. Once I figured out how to not just use cover, but to navigate from cover to cover, it was easier.
Summary: If you are running XP and Explorer, be aware that you could have serious issues and no fixes have been made available as of Feb 2010. Only option seems to be to uninstall explorer completely and use another browser, at least until you complete the game. Activision confirms this. If you can do that, game is fun. Challenging at higher difficulty levels and entertaining, although could be longer.