Goldeneye only for its era. Blasphemous as it is to say this, it doesn't hold up to the test of time at all. Graphics are yuck, even for N64, and the gameplay is only passable as multiplayer anymore, and then only for a little while before the nostalgia glow wears off.
For single player experience, I'd say HL2 (and episodes). Most multiplayer-oriented shooters these days are trash imo, so I can't name a best for that group.
best shooting games would be:
1. COD 4: Graphically it is amazing, Online is phenomenal and it just rocks being SAS gunsmilie
2. Bioshock: amazing game with spectacular graphics
3. Prey: again graphics are great perhaps not as good as others but still great. The game play is sweet but the ending excited me and annoyed me all at the same time 😖
4. Counter Strike: this game is awesome no more needs said gunsmilie
5. Halo: The greatest halo ever made 😄