AFAIK it's mostly remembered for being a 4-player FPS at a time when those were rare for consoles. It was an above average movie tie-in game, but famously doesn't hold up to the sleepover-tinted nostalgia. E.g. the 4-player mode runs at single digit frames per second and the controls are far from ideal for players used to modern dual analog stick controllers
The single player holds up, especially on max difficulty. It's like an arcade puzzle game. And the shooting mechanics (body/headshots + an explicit "aim mode") are really fun and feel great.
Surely. There's really a lot of missions - 20 of them. And they aren't quick either. Combined with the fact that you will lose a lot along the way in 00 Agent.
I should really pick it up again. I got stuck on Surface II. The never-ending barrage of soldiers coming at me combined with the giant map really ground me down.