Both exist. I would say single player games tend to content in the range of 10+ hours. Think First Light, Ghost of Yotei in recent years.
Competitive and multiplayer games will tend more towards what you are thinking. CSGO, FIFA, and of course many others.
But I feel like even that doesn’t really capture the full range of everything.