I think they actually made a Game Boy title for it in the late 90's, but Goldeneye N64 and Duke Nukem 64 were also out then, so I assumed there was no reason to think it would be a better shooting experience than those.
My not hearing anything about that game since then more or less confirms that.