Biggest surprise for length was Dragon Quest VII, the PSX version. Started playing it close to release, dropped it several times and finally finished it years later.
I'd played multiple games in the series before and I think the longest one topped out at 40 hours, so I really was not expecting a 100+ hour marathon like that was (although the very, very long prologue should probably have served as a warning).