As an aside, I enjoyed Civ4 way more than 5/6. They might have hexes and Civ4 (and earlier) may suffer from the Stack of Doom problem but I don't enjoy the dance of units that can no longer stack.
Anyway, I played Civ4 the most (other than Civ1) of the series but, more than the base game, I played way more of FFH2. It's an amazing mod. Sadly, the primary creator went on to work for some other game company. Good for him but not I miss the development.
There were a lot of groundbreaking and amazing turn-based fantasy games in the 1990s and early 2000s. FFH2 is just one (and a notable one at that). Others include Heroes of Might and Magic (primary 2 and 3) and Master of Magic (I believe there was a kickstarter for a successor to this but I don't believe it was well received? I could be wrong).
I don't enjoy RTSs. I like the relaxing pace of turn-based games.