Master of Magic was about the best and I think they used the Civ engine as well.
https://en.wikipedia.org/wiki/Master_of_Magic
Many attempts to remake the game failed.
It is like the Bard's Tale series, hard to remake. The Bard's Tale remake was not as good as the original series for MS-DOS, Amiga, Apple //gs, Atari ST etc.