The single player campaign is interesting enough, but you find that as soon as you get used to a particular weapon's muzzle velocity and bullet drop, the game forces you to swap to a new weapon instead. The slow motion X-ray Kill Cam is pretty cool, but that's the only cool bit/USP of the game. Some games you can go back to time and time again, but not this one, its too repetitive. One play and you're done.
The multiplayer is woefully under-equipped. Its co-operative only and there are maybe 3 environments and each one is only 200mx200m. That must be very repetitive and dull, too, because no-one is online. I don't mean that in a figurative way. I mean NOT A SINGLE PERSON is online, you can't get a multiplayer game started because you are the only guy in the world who's trying to give it a go.
Try Sniper: Ghost Warrior instead, its modern, has really cool rifles and has a slow motion kill-cam, too. The biggest advantages are that the campaign can be revisited and the multiplayer is competitive and you'll never fail to get a game going at any time of the day.
As always though, try the demos in XBox's Game marketplace first...