Guess it depends on the make and model. A VW Jetta S the manual does better on the highway, the auto in the city. For a Jetta TDI manual wins both.
They do screw around with the gearing between m/t and a/t, typically to make the manual “faster” rather than more efficient.