Like others have mentioned, depends on the situation. I actually like staying in Air BnB/VRBO type places over hotels/motels when it's going to be for more than one night since they have kitchens and often separate living room areas. We are also still younger, working stiffs, so the option to drive everywhere for say, a weekend wedding, isn't an option unless we plan an entire week off work around it.
Just a few examples of when it was more convenient and possibly cheaper to not take the camper:
This past summer we went to Nashville for a wedding. Driving would have taken 2 very long days plus probably $350-$400 in gas each way, plus the cost of wherever we stopped for the night, or two nights if we split it up over 3 days. Plus the cost of the RV park once we got there. We ended up flying, using Southwest points, and stayed in an Air BnB about 10 min from downtown for around $110/night, we stayed for 4 nights. We did not rent a car, just used Lyft. We ate out probably as much as we would have even if we had brought the camper, since we had a full kitchen and stopped at a store for breakfast items and snacks, but no way could we have driven our dually in downtown Nashville, so we would have also taken Lyft even if we had the camper. In the end, it was cheaper and more convenient to fly, and this way, we got to actually enjoy the destination since we didn't have to spend half our vacation driving.
On the Friday before Labor Day, we drove up to Laramie for a concert. We've taken the camper before for football games, it's about a 2.5 hour drive with it (about 2 in a car), and stayed at the KOA there. It's $50/night at the KOA. We found a cheap motel room for $75/night. So it was a bit cheaper to stay in the motel because of gas savings, and the motel sucked and wasn't nice but it was just one night. Plus we were able to get there and get back faster, which was important that weekend. But for a game day, hotels are at least $150/night, so the KOA is cheaper for those instances.
But, we didn't buy the camper to save money, or to use it for every vacation. It's just another form of recreation for us. If we were retired and didn't have time constraints, we'd use it more for sure though.