Switch is very good about this actually. My son's Switch hasn't connected to wifi since he got it, and still runs swimmingly. PS and XBox, however, are very different beasts. Often, when a new system update comes out, certain features are blocked until the update is installed. Similarly, you can buy a new game on a physical disc, and find that it requires a minimum OS version, forcing you, once again, to go online just to play the darn game.
Ah good to know. I also forgot the obvious case where a game’s disc only contains a subset of the content on it and a download is required for the rest. It’s not really a day one patch but just the game is too large to fit on a disc.