In single-player maps, I usually level up my hero to a maximum of 18-23. Considering that I use them in pairs.
I don't see the point in leveling up a hero who won't be used in other maps. If they can defend themselves and achieve grandmastery in one or two skills, that's good enough.
But if it's not a single-player map, but a campaign, the situation changes drastically. I prefer campaigns or huge scenarios. Small maps don't seem interesting to me. There, you can't level up the hero, and you don't even have time to enjoy the game.