Watching 3-4 hours of pretty much any adventure game from halfway through is not a good way to gauge a game's quality. You don't feel the pacing or flow, you don't see the progression, you have no sense of context or story, etc. By doing that you're already setting it up to not look very appealing.
Hence it seemed like you were bringing a heavy bias to the table straight-up. Hence it seemed like you were
trying to see it a certain way to begin with.
I think tew2 is okay, but nothing that will bring a huge number of people to spend so much money on it. Especially when it's more or less a given that you can pick it up for half the price four weeks from now.
The market is pretty brutal but we've had many examples of SP games doing very well in recent years.
But the most important factor which you're completely ignoring is that
arguably marketing is more important than product features (or even quality) and we know for a fact that Bethesda are really not pushing this. They did the same with Prey.
And they don't allow review codes before release (which is suicidal for IPs without crazy brand power).
I didn't buy it because it runs really poorly, if it was a good port I would be playing it now.
Performance for me has been excellent but yeah I've got a great rig so YMMV