These games never stopped and are arguably better than ever. Just of the game designers you mentioned:

The Lead Designer of Civ 4 just released Old World. It's designed around reducing end game slowdown by limiting the number of orders you can place each turn, mechanically you play a series of leaders who can only give out so many orders and have to manage their dynasty, Crusader Kings style. An excellent game. https://mohawkgames.com/oldworld/

The designer of Fall From Heaven made Fallen Enchantress and I think a modern Star Control remake. Can't speak to their quality personally.

The designer of the original XCOM recently released Phoenix Point. Haven't tried this one yet but it's on my list.

Turn based tactics games in general are extremely popular. Pathfinder Wrath of the Righteous has a HoMM2 style army battles built into the RPG campaign (though it's reportedly quite buggy and unbalanced...) The game overall is fantastic, and the party-level combat is also turn based if you like. Baldur's Gate 3 is turn based. Some personal favorites are all the Long War variants. XCOM 1 Long War, XCOM 2 Long War, and now XCOM 2 Long War of the Chosen.

Edit: If you're looking for something specifically like Fall From Heaven, I'd say give Endless Legend a try. It has a similar feel in the way it combines theme and mechanics. It came out in 2014 but it's still getting updates and content to this day.