The last 3D game I've really enjoyed was No One Lives Forever. I finished it in three days coz I only play until the end really really good games.
Other examples of games played without resting:
Ambermoon (Amiga Emu) - The best two weeks I spent in front of a computer -
The Dark Heart of Uukrul (PC)
Wizardry VII (PC)
The Magic Candle II (PC)
Broken Sword II (PC)
Rick Dangerous (CPC)
Batman the Movie (CPC)
Turrican I, II, III (Amiga Emu)
Damn Ambermoon. After playing it I'll never enjoy other RPGs. It's simply the best.