Meh. SP mode in FPS games have sucked for a while. I don't even remember playing more than a little way through almost every FPS Ive ever owned in the last 15 years with the exception being the Halo and Gears of War series.
And I don't miss it. The beauty of Golden Eye was its MP mode. We've had online MP mode on the console for a while now which makes MP mode even better and completely overshadows all but the best SP mode.