I don't know how many hours I spent on it in total (probably over a hundred), but it took me 10 YEARS to beat Zelda:Ocarina of Time. I hated that game! i probably restarted it itleast 4 times and still have a hatred of Jabu Jabu's belly!
The longest game I've been working on is the original Castlevania. That game has kicked my tail for nigh 19 years now. Mind you, i only put some time into it for the annual castlevania-thon but still...19 years!
I probably put about 80 hours into Skies of Archadia...great game...Other then that, I really try not to go over 60 hours....I really don't care about side quests and stuff that much.