This is a bit of a strange one and with the release of Cyberpunk 2077 as the latest game in a long list with a multitude of problems on release I thought the question might be interesting. I'm unsure whether to post this in the console or PC section as the experience can be quite different for some titles.
Historically speaking many singleplayer only(based on my experience anyway) games never really required much attention after the initial release.
Multiplayer/CO-OP games were a bit different in that they generally required continuous attention throughout the games life and many more modes/variables/content were added to the base game.
Today everyone(almost) has access to the internet and the ability to push updates to games is much easier.
However, I think somewhere along the line we (the consumer/gamers) allowed the publishers/developers to get lazy and release unfinished broken games.
I have some really old disc games on PC that probably only had 1 or 2 small updates for example through its life and probably were not essential. Original Mafia on pc was a great game and I can't remember needing a major update to play it (could be wrong).
From the console side of things I played every single PS2 game I owned (GTA 3,Vice city,san andreas MGS2 + 3 etc) without an internet connection so I had no access to updates. Now I expect these games did has some issues but not to the extreme we get now.
So the question really is when did we start to accept broken/incomplete singleplayer games or what was your first really unplayable title on release(and the platform)?
And the next question is how do we fix(patch) it?
Reviewers were not allowed access to the console version of cyberpunk before release and were not allowed to show in game footage on PC. Their review scores glossed over any issue as irrelevant.
The days of actually reading gaming magazines and getting demo disks are long gone. The replacement should be far superior but it is actually more controlled and influenced by the developers.
Note: this thread isn't to hate on cyberpunk