I stumbled across this a little while ago. It's pretty cool. They've gone and taken all the Goldeneye N64 skins, levels, weapon physics and the like, cleaned 'em up, and coded it into a Source mod. You DO have to have a Source based game to play it, but most people who play on Steam have at least one. It's fun, but there's not a lot of people playing.
They have really come a long way with this mod, I used to play it way back around when they released the first playable versions of it. I'll pick it up again and try it out, it seems like they have added a lot and improved the mod greatly since I last played it. Another mod you guys might like to check out is Dystopia, which is my current favorite. It is cyberpunk themed team based with different objects and stuff and you get different classes and cybernetic implants and also you can get into cyberspace to hack things to help you take objectives like turrets, extend a bridge etc and its like its own mini game type thing inside cyberspace. It has a lot to explain so just check it out at http://www.dystopia-game.com