Does anyone have any wheeling or ownership experience with an RV and/or travel trailer?

My family has decided we want some means of mobile living. The goal is to have something we could drive to destinations over the weekend and occasionally use to do long drives during vacation periods. I love driving long distances and we both dislike hotels in general.

But I’m not entirely sure where to even begin. My gut tells me to go with a truck and trailer combo - but that’s likely heavily influenced by my desire to have more vehicles in general. I would love to add a unicorn like a gas 2500hd with the nv4500 to the stable.

We wouldn’t be going with something massive. Just enough room for myself, my fiance, and our two dogs.

Any experiences/feedback would be greatly appreciated.