Fun to play if you keep high stealth; then those retards don't walk around shouting all the time. It actually makes a difference if they're just alerted, say from a destroyed light or camera, or have actually spotted you.
It's easy enough to get through a level, but you are very vulnerable; it can be over very quickly, forcing a retry. There's some challenges to get through levels without any retries and without firing a shot or without being spotted; have yet to manage either, very difficult.
In short, it's made rather easy, sorry, accessible. But if you dig a little deeper and play it as a SC game, there's more there than you would have expected. Simply playing without relying on Mark&Execute too much adds to the gameplay.
SP is rather short, but you can play the MP maps solo. Enemy placement is randomized so there's some replayability there too. Much better to play Coop though, really wouldn't recommend getting it unless you have someone to play with. It makes up half (well, 1/3) of the game; really need to get into that.
That said, I really miss some more tactical options from the other games, such as the pistol-mounted gadget to disable lights temporarily, and the GL on SC-3000 with sticky shocker and ring-airfoil rounds.
The problem of not being able to move bodies can be circumvented by grabbing a guy and neutralizing him in a dark corner. To be honest, that's what I did in the other games often anyway, but it still should have been in there.