\MapObjects\_(AdvMapSharedGroup)\Heroes\Any.xdb
\MapObjects\_(AdvMapSharedGroup)\Heroes\Fortress.xdb
P.S. Please don't suggest downloading other mods with +1500 heroes.
Added 29 minutes later
I figured it out myself, here's the solution: Hangvul has this line filled in the original Hero file from the Lords of the Horde:
While other campaign heroes do not have it, and because of this, the hero is not visible in the hero selection window. Or maybe this is a specific problem for the game with a 4K resolution. In any case, deleting this line made the hero available for selection.