Goldeneye seems a bit crude by today's standards, but for the time it was a solid game. The graphics were good for 1997, the music was good, it had solid gameplay, multiplayer was fun, replayablitiy was high, the maps and levels were generally well thought out, a n00b could pick up the basics easily, and the single player mode had an engaging story line. In 1997 it's not like many people had 3D cards in their PC, nor did they have an easy way to do multiplayer with three other people as most people were still using dialup and a NIC was still somewhat exotic. But getting together and popping in a game like Goldeneye was quick and easy fun for a small group of friends.
Granted, by today's standards the graphics are crude and low res (especially in split screen mode where you end up with 1/4 of a standard definition screen, yeech), the AI in single player mode is braindead, and the controls were always a bit clumsy and inevitably you would get "Nintendo thumb" after playing for too long. But that doesn't make Goldeneye a bad game because Unreal Tournament that game out almost a couple of years later is so much better.