Not too familiar with jrpgs, my best suggestion is that you'd probably have to combine Tactics Ogre (for the hour long fights) with something else

Basebuilding strategy fps with tensile strength of..

minus the FPS, this is just dwarf fortress

dwarven rhythm games have supply line minigames

I'm pretty sure this is a reference to a specific game but can't remember much about it

Mortals cannot comprehend dwarven grand strategy games

definitely the campaign for north africa (or any other game by Simulations Publications)

halfling games: I've got nothing

goblin games: the gacha screams "any online card game", and the moba should be easy to find too. Left as an exercise to the reader.

orc game: I'm thinking this is about 10% of the games on newgrounds. You'll find these amongst general flash game collections for sure