I'm gonna say the Xbox/PS2 era Bond games were amazing!!! Nightfire, From Russia With Love, and Everything or Nothing were awesome.
From Russia With Love was poop imo with for instance some extremely repetitive boat shooting sequences. I really liked Nightfire and Everything or Nothing like Jeff mentioned though. Especially the "bond moves" thing they had in them.
It kind of sucks when a series is connected to an IP like this since the chance of seeing re releases of previous games small (this being a remake). The best thing would have been a new game with a story not based on any of the movies though, like Everything or Nothing and Nightfire. Although not with gameplay like this.