Honestly even if it's not multiplayer, if it's an actual single player campaign, don't get too excited because it just can't be like the older games.
At this point I really think that Ubisoft just aren't able to make a game with a specific design, something that isn't part of their general formula. Every games they've been doing for years have been following their open world / Assassin's creed formula, even their racing / sport games.
If you get a new single player Splinter Cell game, it will most likely be an open world, with camps / bases to clean, and cleaning these will fill a gauge, and when that gauge is complete, you will unlock an actual mission to finish the region, and move on to the next which will follow the exact same pattern, during the whole game. You might also have some side quests / tasks to do, probably with maybe 5 type of different objectives to do, repeated and spread around the whole map.
I'd like to be wrong, but I don't think I am, and I even think that most employees working at ubisoft now probably don't even really know how to design something different than this, because a lot of developers working there, who joined the company during the last decade, probably never did anything different than this and were just trained to do this.
It would be nice if one day they could actually do a specific, unique game that is its own thing, but they gave up on this idea.