Just look at the achievements list of basically any game, and no matter how good, a large majority of players will usually have dropped it before the end. That right there is a pretty good indication that games in general are too long, even disregarding any problems that Starfield had in particular.
I've shifted my playing patterns to shorter games, since I *do* want to see the end of them, but I also don't want to spend a huge amount of time with them.
But I've noticed that even the shorter ones have huge player drop-offs. Sometimes as early as the first achievement-granting action in the game. This kind of suggests that there are far too many of them, too.