Half-Life 2 wasn’t designed to be a great game. It was designed to launch a digital storefront that allowed Valve to rake in 30% of all revenue for games sold on the platform - which is often a larger percentage than is paid to the actual people making the games.
Those things aren’t mutually exclusive. It was used to launch Steam, but it was also an objectively great game because Valve cares about their craft.