From a player perspective, you're wrong. Go play something like Outer Wilds, you'll finish it in a few hours, and the game will never be the same after you finish, but it will leave an impression as strong or stronger than 10,000 hours in Factorio.

From a game publisher perspective, you're right, you want to create "lifestyle games" that players can put 1,000 hours or more into. These games are more likely to sell because YouTubers and streamers will find a niche publishing content for these endlessly repayable games, and that will attract a lot of eyeballs and drive a lot of sales. If your game is "just" an incredible story and experience, then a lot of people will experience it by watching their favorite streamer play the game, and then they will never play it themselves. Source: https://www.youtube.com/watch?v=sIqz5xmQKnc