I'll be rather unoriginal and say Goldeneye is still a big favorite of mine, and what's interesting is now it comes in two flavors. First is the N64 original by Rare that uses the likenesses of the original actors, and helped pave the way for quality console shooters (since before this shooters were considered to be "only good on PC"). Yeah I know some aspects of it haven't aged well, but there's no denying the huge legacy it made.
And of course second you've got the reimagining developed by Eurocom for the Wii (though the 360 and PS3 got an enhanced port later) that redoes the movie's plot with Daniel Craig's version of Bond. Yeah I know this one's probably me cheating since this isn't a direct adaptation of the 1995 movie, but rather a reimagined update with the most recent Bond and completely redesigned levels and new mechanics (the game was built off the CoD engine and as such does feature mechanics from CoD, but there is a Classic setting that does do things like turn regen health off), but it's such a very well made retake on both the movie and the original game that I like to count it anyway.