Personally there are a few games which left me very dissappointed, after hyping myself up for years in certain cases.
Divinity Original Sin: turns out I prefer more streamlined, less packed games (love Pillars of Eternity) and that coop play in a CRPG stresses me out.
Wasteland 2: I actually managed to finish this one but secretly I admit I was hoping for a better Fallout which I didn’t really get. New Vegas did the cowboy theme much better.
INSIDE: while the design was cool, it was just a ton of boring, easy puzzles in comparison to LIMBO, its predecessor.
I don’t know, if I’m honest, if there is one AAA developer out there that makes games that will keep me engaged for at least a couple of hundred hours, it’s probably Bethesda. I think Starfield will be the same. Will there be bugs: yes. Will it be a variation on a well-known theme? Most definitely. Will it be less good than the hype: very likely. Will it be totally worth it nonetheless: probably yes.