I never played it, but it sounds cool.
The Splinter Cells were very good on the original Xbox, I remember being amazed by the shadowing and graphics back then.
In terms of Bond, N64 Goldeneye, Tomorrow Never Dies on PS1 and The World Is Not Enough on the XBOX I think. That's the ones I've played. All pretty decent, mainly because of the Bond Franchise and story kept it interesting and playable.