Actually, Dragon Warrior 7 is one of them, although it doesn't take 100 hours unless you're going to do everything, and even then it's under 100 hours. I think I finished the game with most everything completed in 60-70. Haven't finished everything else up yet, but my save data is sitting at 80 hours with just the secret area I need to complete. I've also captured some, but I think capturing every monster in the game for the monster farm might push it beyond 100 hours.
Depends though, because it could also be Tactics Ogre. First time playing through Tactics Ogre and completing everything, including Hell's Gate, all characters at 50, all rare equipment, a few Liches and Hydra's, etc, took me 80 hours, but that didn't include any of the other paths, and there are three paths in Tactics Ogre, so technically you could say the game is around 100-120 hours to complete if you talk seeing all of the main story alone. Tip for anyone interested getting super OP angels. Recruit them in the battle with Bishop Branta and they'll have the best stats you can get withoutusing the Necro/Rebirth trick or using stat enhancers.
I've also played Dragon's Crown for 180 hours. So would that be considered the longest. :P. The Labyrinth of Chaos is 100 floors with three randomized maps each. Mirage Tower might have more. I've gotten to Ultimate difficulty with every class. One of my favorite games of last gen.
I'm also playing Fantasy Life on my 3DS and right now I have 40 hours, which is only going to go up. It's basically White Knight Chronicles 2 meets Animal Crossing meets Secret of Mana.
