I am not exaggerating when I say it is the best FPS campaign I have played in a long time. And as a person who is also not huge on multiplayer, even that is really fun.
I personally think it's better based on mechanics rather than story. Like, it's not super long (it took me 7 hours), but I thought every moment of it was enjoyable and everything felt great.
