I am lucky. I travel with my dogs all the time. I have Gordon, the beagle and Ambrose, the lab/rottie. They love travelling and get excited when they see me moving my camper around in the back yard. Honestly, I can really only handle one, and often Ambrose is left with his previous owner if it is at all possible when I go to gatherings.
They would be perfect if I could get them to not bark when I to leave them alone even if it's just to go to the washroom.
They can and do sleep in my camper with me occasionally. It's a tight fit with my trailer being a whole three feet wide. I like covering my camper with a First Up (which got destroyed last year, so a replacement is on my shopping list for Fish Creek next week), so if it's hot and dry, I will drop the wind walls, put their bed on the ground and encourage them to sleep outside. I'm also lucky that they seem to have stomachs of steel. They'll drink lake water and not get sick. Since I like to come to the US to camp, I need to buy food for them in the US, but not too much due to not being allowed to import dog food either way. I now give them Beneful, which is not the best food, but is available in both countries, and is likely from the same factory.
If there was one thing that I would really appreciate being able to better handle is the heat. Last year when I went on holidays, I went in July, and was down in Indiana. I did not feel safe leaving the dogs in the car for even 15 minutes while I went into a grocery store to get food for us. Between campgrounds, I ended up driving in the daytime with the AC blasting and setting up and getting supplies in the evening. Puttering around cities was just out of the question and I missed seeing Chicago and Milwaukee, ending up in Green Bay, which was a nice place to wander around. It was still ridiculously hot there at 9PM when we arrived. We got a break near Sault Ste-Marie, but by then we were getting to the end of the trip. If I could keep my dogs cool while I deal with the work part of road trips I would be happier.