does this game have a story or is it like little missions like a mobile game? I've never tried it because the third person perspective is kind of a turn off.

Very long and rewarding missions. At the later stages alarming the enemies and having to run away and then back again becomes somewhat tedious, but overall it's a great game worth checking out.