Talking of smaller motorhomes that could also double as a cool toad, that website had an article on Ford selling Transit Custom motorhomes in Europe from dealers in a few countries.
https://newatlas.com/ford-nugget-camper-van/58176/
Apparently, they have a pop-up and a tall roof version. One even has a restroom without a shower. Beyond serving as a toad, they may also be great for traveling, tailgating, or short weekend trips (if only they were imported to US).
I like the high-roof although it looks a bit tall for its width. The pop-up should be garageable, a real plus if used as a second car.