Good luck out there. We just did a 5 hour drive with 2 dogs to go check on the MIL. Sounds like we’re the exact opposite of you. We have one of those back seat dog hammock things, which are great, and they literally fall asleep back there before we get out of the development, and pretty much sleep the whole way.
Of course, the dogs adore the car. The cats, however, are hell-on-wheels. They make sure that we are as miserable as they are for the whole drive. This usually includes a vengeful stinky poop as early as possible in the trip.