Is that even a guarantee though? In particular, I know that you could buy the Orange Box (HL2, TF2, and Portal) on DVD in retail stores, but you needed a Steam account to play anyway.
Except the Switch.
There's a Twitter account that documents if games work without having access to the console's network/stores: https://twitter.com/DoesItPlay1/status/1474819155173908484