Driving missions aside, there really isn't anything to distuingish Nightfire from all the other FPS games out there. Even so, it has tried-and-true fun FPS gameplay, so if you're a shooter addict with nothing to do, give the game a look.
I, like so many others, am a huge James Bond fan, so I looked forward to this game. Sadly, the Bond license isn't used to great effect. The plot, villain, and female leads (all staples of a Bond game/movie) just aren't that memorable. Even most of the missions aren't particular compelling. On the plus side, the graphics are great, and there are some extremely fun and destructive missions involving vehicles.
For multiplayer...well, if you have Halo, theres absolutely no reason to get this for its multiplayer aspect.
All told, Nightfire's not a bad game (I certainly had fun playing it). However, know that, if you get it, you're basically getting your average FPS with Bond skins and the Bond theme song.