We moved from Louisiana to SW Florida with two dogs and two cats. The cats rode in a carrier sitting on top of each other (with an old bathmat in the bottom of each carrier) and the dogs sat on both sides of the carrier hooked up with their seatbelt harnesses. We stopped at a hotel after about twelve hours on the road that accepted pets. It was not good. We let the cats out of the carriers, set up a litter box for them (and cleaned out the carriers), set up food and water for all the pets, slept a couple of hours and got back on the road. Drove the rest of the way, checked into another pet friendly hotel where we had planned to stay for two or three nights and again it was not good. This hotel room had carpet and a full length mirror that freaked the cats out. We found a vet to board all four pets for two nights until we could get into our new home. But that was delayed so they stayed boarded for another two nights and then we freed them and brought them to the new house with no furniture (we slept on patio furniture in the house that was left by the previous owners until our furniture arrived a few days later). We didn't give any of the animals any sedatives, just used a calming spray for the cats that I found online.
When we had to evacuate for Irma six weeks later, they all survived a 15 hour drive to Georgia pretty much the same set up. Only we didn't have to stay in a hotel; we stayed with friends. The drive back to SW Florida after the hurricane took about ten hours and everyone was glad to be home.
Each time we drove with the cats, we had the carriers out and open in the house for a few days to get them used to the carriers. Plus all the time we showed the house we were selling, we had all the animals in the car with us, cats in carriers, dogs on the back seat for an hour or more.
Another time we moved from Eastern Montana to Louisiana (about 1500 miles) with three cats and one large dog. We stopped twice and the dog had to sleep in the car both nights (she didn't like the cats at all). This time the car was an 8 passenger minivan and the dog had the back seat, the cats were all in carriers in the back end of the vehicle. This trip was in late October, and it was cold in Colorado when we arrived there the first night. We had planned to board the dog overnight at a boarding facility, but we arrived too late because we got caught in a snowstorm leaving Montana. We went out to the car a few times during the night to check on her and she was fine. The worst thing was we had four cats and we couldn't find the fourth one the morning we had to leave. We thought she might have gotten out while the movers were loading our furniture, but she was hiding in the house and we didn't know that. So we had to leave without her. When the new owners moved into the house, they shoed her out of the house and she nearly died from the weather and lack of food and water. They took her to the vet to have her euthanized and the vet, who was our vet, recognized her and called us. The vet got her healthy, drove her 150 miles to Billings to get her on a plane and she flew to Louisiana. The vet bill was expensive because they went ahead and paid to fly her as well, but we got her back and she was with us for another five or more years. It's harder to fly animals these days though.