If you just checked out the James Bond Nightfire demo (or not), and are wondering what the full versions of the Xbox and PC ports are like you can check this preview on GameSpy. Unfortunately, the PC version is described as "rough".