I think 25 hours is a good number to shoot for, excepting multiplayer-centric games which have almost infinite replay value. Games which exceed 25 hours usually just stretch existing content in some way to achieve it (sorry, Zelda, I love you anyway).
To Bod's question: I think I'm realizing that I prefer short session. My copy of RE4 lies uncompleted and it's mostly because I can't just pick it up and play it for an hour. I just feel a need to really get into a cinematic game like that, and the opportunities are few.
"The worst part about these reviews is they are [subjective]--and their scores often depend on how drunk you got the media at a Street Fighter event." — Mona Hamilton, Capcom Senior VP of Marketing
*Image indefinitely borrowed from BrainBoxLtd without his consent.