It's not a bad game, but it's certainly not in my top 10 either. To best summarize it, I think TFH is the best of the worst Zelda games.
I don't think TFH even touches LOZ, ALTTP, LA, OOT, OOA, OOS, MM, TWW, TMC, TP, SS, and ALBW.
At the bottom: Four Swords was a sandwich short of a picnic...