One from me, there are basicaly three big mod mods for FFH2, Orbis, Rise from Erebus (Formely Fall Further), and wild mana. All of them are based on FFH2, but on top of them, they change gameplay, balance, add more stuff etc.
Orbis is quiete good, but it is not that much updated lately.
Rise from erebus, did not have update for an ages. It is most stuff packed mod. However, AI is the weakest part.
Wildmana, has best AI and some nice stuff, its not full of godies like other ones, but does provide better chalange.
I like wildmana best, simply for AI. Its fun to play with stuff for a while, but without much chalange, it gets boring for me. Also, wildmana is still quiete alive, with beta test of version 9, which is sweet