I never really thought of the Metroid Prime series as first person shooters. I suppose they more or less qualify as members of the genre, but something in me hates to classify them as such. First person adventure seems to be what they're typically classified as.
Nintendo has never remade Goldeneye 007. It's apparantly caught in No Man's Land since both Nintendo and Rare (MS owned) hold rights to it and obviously both want it on their console and not the competition. You're thinking of a brand new Activision game that utilized the same movie license (And clearly took some inspiration from the N64 classic). Was recently ported to HD consoles as well.
It doesn't have local multiplayer, but just in case you ever considered it for single player, stay away from Brothers in Arms Double Time. That was $50 wasted. Loved both games on the Xbox so I wanted to see how their conversion turned out on the Wii. That was a mistake with very poor motion controls, no GCN or Classic Controller support to make up for the lousy motion control implementation, the ports were based off the PS2 builds rather than the PC/Xbox versions (Not an issue so much on Road to Hill 30 where they were fairly equal, but it really hurts the sequel that had some great AI on the Xbox version and some other enhancements that aren't here due to its PS2 heritage), an unsteady frame rate that gets very choppy when the action gets busy, and various other technical glitches that are in abundance like lockups.
I enjoyed Medal of Honor Heroes 2. But I can't recall if it had local multiplayer (It did have a well recieved online mode though). And the already mentioned Conduit game has a sequel and if the first one rates a mention, the improved sequel certainly should.