Goldeneye just isn’t a very good game. It was one of the best fps games on the N64 so if all you’ve got is an N64 you’re going to think it’s amazing. But other games have done much better what it tried to do so today it feels clunky and bad. Contrast to something like Doom which still holds up today because that style of gameplay hasn’t been massively improved on.
I’m so glad I went back and finished it recently. The MQ story is really good. I put on a mod to make magicka regenerate like in later games and played a straight mage, eventually crafting rings to be able to jump around town super fast and another to cross the continent.