TWO CATS and one small dog.
When we retired 2 years ago and started snowbirding, we had no choice but to bring them with us.
AMAZINGLY - they LOVE IT!
I have two wire crates in the car that they travel in. Yes they have cried occasionally while riding in the car - but 99% of the time you do not know they are there. We transport them from car to camper in a soft sided carrier so they don't get startled and flee.
They actually seem better in the camper than at home.

NOTE: these are indoor cats - outdoor cats would be a "whole nuther matter".
Now, when ever we go somewhere, they always just come with us.