How long does a game have to be to justify a purchase??

Do you really want a game that just goes on and on, wouldn't even the best game loose a little of it's lustre??