Valve and Steam Works games happily sold literal trash that were useless to anyone but the first person who redeemed the key. They destroyed the second hand PC market selling codes in a box with potential time saver installers. And they still needed online activation.
I too bought a Steam Deck and haven't looked back. It's still a normal computer even if Steam itself goes to shit, but all signs point to it steadfastly refusing to do that. Here's to hoping Gaben never dies.
You could, at least hypothetically, put every physical cartridge in a Switch or Switch 2 and download all the updates to those games, and just have an offline mirror of Nintendo's entire update CDN. More likely someone should make a homebrew app that archives update data by using this weird peer-to-peer update protocol, but I have no idea what encryption would need to be broken to make that work. But it would be a legitimate boon to game preservation to have something where someone with a bone-stock Switch and a game can just download the update they need and be done with it.