I enjoyed GoldenEye: Reloaded. It's basically a 007 mod for CoD4, and it actually has music that plays during matches. Lots of different game options, including character skin selection, you can turn off health regen and use body armour pick-ups like in the N64 game instead, and all sorts of fun stuff.
Other than that, I'd say CoD4 is your best bet. I pick that over the other games in the series because the maps & weapons are better.