COD 4 Then it all went tits up. Insurgency I would say is the best 'current' FPS, but no single player option really, only very good co-op modes
not first person, but Spec Ops: The Line is a bloody good single-player third person shooter. Makes you feel like sh*t afterwards though. If you want something other than a corridor shooter, try Far Cry 3
I thought all of the MW series were good ( I never played COD 4) but out of the them i think MW2 is the best. Borderline with MOH 2010.
Then it all went tits up.
Insurgency I would say is the best 'current' FPS, but no single player option really, only very good co-op modes