It looks like you’re primarily interested in RNF style fantasy games? And not so much larger scale fantasy skirmish? As such, I’d say War of the Rings (GW’s LOTR game but with regiment trays that the round-based minis slot into) and CMON’s A Song of Ice & Fire (again with unit trays with round holes) both deserve a look. I know relatively little about either, but have heard years of praise for WOTR, and ASOIAF is picking up some speed, having recently pushed into the North and the more fantastical Wildling stuff. I actually like how both systems handle heroes, though they’re entirely opposite - WOTR heroes have dice pools that allow them to do epic things, while in ASOIAF I think heroes are largely upgrades to units, as they slot in ala WHFB. Could be dead wrong on that last one, trying to remember what I’ve heard.
I’ve loved Wargods’ minis since they were first released, and hope to have at least one KOW army made from Croc Games’ minis. Spoiler: I already own dozens of Sebeki dudes, waiting for KOW 3 to make Ogres a little more worth playing
If you are interested in fantasy skirmish, there are tons of contenders, whether OOP (Rackham’s Confrontation) or headscratchingly popular (GW’s Age of Stuff). When it comes to AOS, I’ve actually played it since it dropped, and tend to give it a try every time they readdress the rules. It’s come a long, long way from the ‘Just Four Pages Of Rules!’ days, but ultimately it’s still pretty under-designed and imbalanced for me to care too much. It doesn’t have as many NPE (Negative Play Experiences) as it used to, however there are still some really galling rules in there that GeeDub apologizers continue to defend (double turns are bad). All that said, I have a couple WHFB armies that I’m not interested in porting over to KOW - Tzeentch Daemons, for example - and still rollout for AOS if friends want to have a dumb time and roll some dice. If nothing else, the level of carnage in AOS is extreme, which sometimes is what the doctor ordered.
This is already a long reply, so I guess I’ll say that I have thoughts on WHFB too if we’re doing a postmortem on that game. I played from the end of 4E to the End Times, with a break for 6E when I went to college and mostly played 40k, and you know what? I don’t need to go back. WHFB had some deeply obnoxious things in it, and bless Mantic for creating a game that captured and refined the strategic mechanics of the World That Was without the piles of nonsense that went with it.
EDIT: Here I’ll acknowledge that both WOTR and ASOIAF are pretty well tied to major properties that may or may not be interesting to you. LOTR, for example, leaves me entirely cold, thus I have never wanted to invest in WOTR.