The exception to that is highly social games. I did genuinely feel a sense of accomplishment when me and 4 friends would crush another team in league of legends. Or the old World of Warcraft raids involved coordinating 40 people and felt meaningful to execute.

Maybe there is a future where video games optimize around giving life meaning once there is little work to be done.

Designing a game where the goal was to create strong friendships between players would be a pretty interesting task.