The hero promotion gives a 100% discount on upgrades and the adventurer promotion gives a 50% discount. These are additive so an adventurer, which has both, actually gains half the normal upgrade cost.
(I've personally given adventurer a 100% discount, and allowed units with hero and/or...