I'd say Black Ops I & II win for single player, to me single player is where CoD games usually shine, and the mulitplayer is boring.
moh 2010 had a nice bnut short sp imo not actionpacked like COD blockbustre style more realism fun
If that's what you're into, try ArmA, brilliant campaigns.