Songs of Conquest is a spiritual successor you might be interested in checking out. I agree HoMM3 is still great to revisit and SoC doesn’t quite scratch the exact same itch but it’s a good way to get more of the same but with some variety keeping it fresh