I didn't think it looked good and I had everything on the highest they could be. I thought CoD4 looked great and played smooth, but ths looked sloppy. Bond himself looked like a clay sculpture covered in shellack, almost like Lionel Richie in that music video, except more shiny.
Gameplay felt like CoD4 if it had a basic cover mechanic. It wasn't nearly as good as Gears, Uncharted, Dark Sector, Vegas or those types of games because it felt so basic, but this doesn't rely on the cover all that much. The enemies are brain dead and it is basically a battle to see if you could sync up your popping out of cover with their scripted popping out of cover. The actual mechanics of it felt like Rainbow Six Vegas. Maybe it gets better as the game goes on or something, but the demo only had a small shoot out in it.
Oh, and for some reason when you are low on health you lose 80% of the screen to a shitty gun barrel effect.