I’m sure there are others, but it’s really not as uncommon as you’re making it sound, especially for AAA titles. I’d also argue it’s disingenuous to say that No Man’s Sky has “very little else going for it”. It was shit at launch, but they’ve built a really solid game now.
Again (and I feel like I need to keep re-iterating this, because people on this site are so sensitive about any criticism to their favorite games) Starfield is fun. That just doesn’t mean that it couldn’t have been better, and there’s nothing wrong with pointing out the areas we feel it fell short. Really, I think what Yahtzee Croshaw said about Tears of the Kingdom applies here - “If the game had these things, you wouldn’t be saying they didn’t matter”