This is an important point! A couple times we've done marathon driving sessions, and we always experience a backlash the next day: that is, we're exhausted, and we spend a good bit of the next day conked out; that, or we're like the walking dead and don't really enjoy whatever we came to see. Specifically I remember a time when our children were toddlers; we drove all night and half the day to get to get to a destination waaaay down in Florida near Everglades National Park. The kids were great: the slept soundly in their car seats, enjoyed brief stops for breakfast, etc. and then went straight back to sleep. But when we arrived, we had wide-awake kids who were ready to hit the beach . . . and parents who were exhausted and ready to hit the bed -- it wasn't a good combination in the hotel room.
This question comes up frequently, but pushing yourself waaaay beyond your limits just isn't smart or safe. You can't cheat your body and expect good results.