There are different goals with games. For the author, they want a specific genre that hasn't really been done before (massively multiplayer co-op) because they want a grand unified goal to cooperate with people towards.

That doesn't mean that games are boring though, especially when looking at the subset op mentioned. In most of those games the goal is to beat your opponent (with the exception of metal gear and payday) through dexterity or skill - it's high intensity and can get hollow when you stagnate in skill level.

Other goals might be engineering success (factorio, dyson sphere project, satisfactory), or unique experiences (stanley parable, superhot), or group fun (among us, gorilla tag), or just a great storyline (disco elysium, undertale, hades).

One goal might be played out for OP, but there are many other ways to enjoy games.