Americans may not have cared for the Hero at first, but I think over time, the Hero's inclusion in Smash helped Dragon Quest grow in popularity in the West.
The way they knew it was Hero the moment they heard the overture reminded me of when Maximillian Dood knew it was Cloud in his trailer the moment he heard the opening notes of the train theme.