auto vs. 4spd, the age old question

From an engineering standpoint, wouldn't the extra gear in a four-speed allow your engine to stay closer to your ideal power band than would a three-speed automatic (or manual) trans? I am thinking of RPM drop when shifting and engaging the next higher gear. Is it correct to assume that an engine with higher torque would be less affected by the RPM drop?