An almost impossible question to answer, as other posters repeatedly pointed out there’s simply too many variables. If we all got together compared notes we’d be all over the map. If you’re talking a big RV or MH and stay in commercial parks with HU’s I’d say no way could you beat the motel route. Depreciation is the big hit, meals out can be next depending on family size.
Now if you have a small TT like mine, dry camp in national forests for free or less than $10.00 a night, get decent mileage, keep it for 25 years to spread the depreciation out, and so on, you can beat the hotel costs. I once spent 4 days in San Diego and calculated I could have made a 3 week trip to Yellowstone for the same money. The longer you’re out the more the RV pays off, too. Most buy RVs for the lifestyle, not to try to save move over hotels and restaurants.