Yea eventually you'll fall over from exhaustion if you stay up too long drinking coffee.
I think you're more likely to get nightmares too, if you keep yourself awake for too long, but not 100% sure just something I felt like was happening in my playthrough.