At least 20 of Babe Ruth's HRs were actually what we now call "ground rule doubles" -- but that was the rule then as Zeke mentioned.
Back to the issue at hand, here is the answer from the baseball rules (and it has already been mentioned , this is only the ruling). The only exception I believe is a HR, otherwise there is no 2-base advancement to win a bases-loaded tie game in the bottom of an inning. Everything else is considered a single:
10.06(f) Subject to the provisions of Rule 10.06(g), when a batter ends a game with a safe hit that drives in as many runs as are necessary to put his team in the lead, the official scorer shall credit such batter with only as many bases on his hit as are advanced by the runner who scores the winning run, and then only if the batter runs out his hit for as many bases as are advanced by the runner who scores the winning run.
Rule 10.06(f) Comment: The official scorer shall apply this rule even when the batter is theoretically entitled to more bases because of being awarded an "automatic" extra-base hit under various provisions of Rules 6.09 and 7.05.