While I get where you’re coming from, Fallout 76 was a bad example, you don’t need a subscription to play (unless your preferred system of choice asks you for it regardless of the game you play) and it is intended to be a multiplayer first game, you might not like it, but it is not an example of what you’re complaining anymore than Elder Scrolls Online or World of Warcraft (which actually has a subscription model).

And the answer is simple, don’t buy those games, there are thousands of excellent single player games, if always online games start to fail companies will stop doing it, vote with your wallet. I recommend taking a look at indie games, there are several excellent games and almost assuredly they don’t have DRM, or at least not always online ones.