Could probably pull off 5 - 6 hours each way if it was a "must attend" family event that didn't take too long, assuming we had to make a showing for a couple hours and really didn't want to get a hotel.
Years ago, I'd leave at 5 in the morning, drive to Cedar Pointe for opening, stay till...