I have it for the PS4, and I have to say I kinda like it. It's got several err, levels, or dimensions to it.
The first part is the regular storyline, basically getting from level 0 to 30 and doing all the missions. I didn't find the story too compelling, I found it hard to follow and halfway through the game I was like "wait what is the game actually about again?". Probably because it's a very er, non-fantastical story, no or very few recognisable characters (all of the safe house quest people look kinda sameish, but they tried to stereotype them in their speaking mannerisms / tropes), it's like you sorta observe the story from a distance instead of being an actual part of it and playing a particular role in it.
That part of the game is challenging enough, no real need to grind all the sidequests and encounters, etc. I did want to dislike this part of the game, because especially the sidequests and encounters follow the game design strategy that Ubisoft set out since Assassin's Creed - open or semi-open world, repetitive sidequests. I wanted to love Asscreed, and I did for the graphics and atmosphere, but the gameplay was just so repetitive that I barely managed to finish the first, tried and failed to finish the second. I tried Far Cry er, 3, but that one just tosses you into an open 'goan do these sidequests, see if you progress the game' world after the initial story bit.
Anyway, oddly enough, I didn't mind it too much in this game. The sidequests are short enough, sometimes rewarding, and the gameplay is quite fluent, even if it's a shooter on a console (which I don't like). The missions are pretty cool too, I've done most with random internet strangers which really is the way to play the game - I'll feel sorry for those that join the game later and find nobody to play with, since the game doesn't seem to encourage high-level players to join low-level players getting through missions. This may change later, games like Final Fantasy XIV have handled this elegantly (where its equivalent of dailies involve replaying low-level dungeons with your stats adjusted for the level of the dungeon, although you will still have a definite advantage over newer / lower level players). Maybe they'll make a change like that once that becomes relevant, it seems there's still plenty of new players (like me) to not make that a problem.
I've only recently reached level 30 and started the endgame content. This quickly becomes more reminiscent of Diablo and the like, with random gear drops, crafting, gear levels, and - eventually - character builds. I'm not sure if I'll play for that much though, it's a random number generator and getting items and whatnot feels a lot slower or less gradual, less satisfying than in Diablo (Diablo 3's gameplay is very smooth and er, 'flow'-like). I've played some hard mode missions, the other players just race through them, don't even (need to) bother with cover and such much, for them it looks like it's just a thing they need to do today for reasons.
TL;DR: main game is decent enough, endgame is only for the hardcore that haven't been burned out on Diablo yet.