Do people genuinely not realize that sony and microsoft had a great data collection source (console gamers) that have largely "aged out"? This new push for account sign-ins is obviously because their user data flow needs a big kick. They used to get data when people bought the game on their own platform, ran it on their own platform, even how many hours their gameplay sessions were individually throughout the week. With a lot of their studios games they had either complete or timed exclusivity to really find out what was driving gamers to game, and beyond that it's a popular commodity and likely a loat or reduced revenue stream.
With helldivers 2, the account controversy sprung up on the back of Helldivers 2's stats page not showing correct numbers for anything (and sometimes being rolled back asynchronously from your currencies and unlocks). Seemed obvious to me at the time they wanted a head count from another source (a sign-in) and probably data beyond that like session time/length. Whatever people are upset about sign-ins over, I don't actually see it articulated much; there are a lot of good reasons to dislike it (potential stoppage of the service causing games to be harder to play like end of service for Games for Windows Live) and I never see them mentioned, just general vitriol for the companies. I don't find the companies sympathetic, but I do find it odd that people just slam it aimlessly everywhere instead of identifying the issues beyond basic understanding of privacy fears.
NMS was quite literally a different looking and feeling game with maybe 5% (yes, twenty times less) of the current content and gameplay loops. Everything changed from how long it takes to gather basic resources to what order you get them in, the tutorial was streamlined and the way it picks the planet you start on was changed. There's an unbelievable amount of things to do, to the point that expeditions started existing to give players a more guided experience with fresh regular content. It's truly a far cry from where it launched, even space stations (the most static structures found in most star systems) have been overhauled and the old ones are only around as easter eggs now.
CP2077 integrated a ton of content and features from the most popular mods it had after the Anime update (particularly Vehicle Combat, from which it even took improvements to the way police spawn and act in addition to, yknow, the vehicular combat). Only a few of the core systems changed, mainly quickhacking and the way cybernetic implants are handled (also almost straight up taken from a mod). They did a balance pass on guns and made some of the weapon type features a bit different. If you didn't push too terribly far through the game on release, none of it would seem different really. The locations and behavior of weapons and enemies in general gameplay didn't change much, but access to mobility via implants was made easier (as the separated stores for them were largely equalized and merged) so it's easier for fresh players and people not using guides to finish their "build". Not quite the huge makeover NMS received, but it's definitely different in terms of progression.
While you're probably right to some extent about naysayers decreasing naturally over time, both games now have suspicious steamcharts numbers for being single player experiences. They get an influx of new players regularly in ways other similar titles don't, and it's almost certainly due to the changes in opinion of people who were playing them around their major updates, journalist articles or enthused friends.
TL;DR: No man's sky really did change that much. CP2077 didn't go as far but they've clearly made end user-oriented changes that are uncharacteristic for single player experiences.