Black Ops Cold War is surprisingly the shortest Call of Duty game at just over 5 hours. Despite its length, it has a memorable campaign with rich and detailed environments. Vanguard, with a 6-hour campaign, was met with disastrous reception due to the new cast of characters.

But it doesn't matter which console you get you will not need a internet connection to play the campaign or zombies. Your son can probably play multi-player locally in split screen. So you'll be fine without a internet connection.