At least have you played the Wii version?, it's exactly the same version the older brother systems are being based for the HD release.
I rented the Wii version last year and while it's quite entertaining, I couldn't help but to think I was playing the wrong game in the wrong system. I liked the Wii-motion controls (maybe the only person in the world who used the fucking Wii controller, instead of the snazzy golden controller), but every single trope in today's shooters were used by Goldeneye.
Two weapon limit?, check, cover system?, check, shrugging off blood in your face after hiding somewhere?, check. Sometimes I was forgetting I was playing a James Bond game and not freaking Call of Duty with russians and cubans... you know what?, it is Call of Duty with sexy bitches and lots of cool gadgets, at least it tries to emphazise some stealth segments and when shit goes down, the mission is not over and you have to kill lots of baddies.
And no, the N64 Goldeneye is not great, take off those damn nostalgia glasses and see for yourself.