Along with Mario Kart, GoldenEye is the N64 multiplayer game. I can only assume by you not mentioning it that you already considered it, as I cannot imagine that game escaping your memory.

I don't play a lot of multiplayer FPS games, so I don't have any PS2 recommendations.