The cost of our vacations often depend on our plans. If we plan to travel for many days it's much cheaper for us to stay in a motel/hotel than to pull our trailer. I have to factor in gas along with accommodations. The extra cost of a full day of towing a trailer and the CG can far exceed the cost of a motel room.
On the other hand, sometimes we only travel a short distance and spend a week or two in one place. With this route the trailer is less expensive.
The trailer is always more comfortable than most any other lodgings though.