My thoughts are more in the direction of a panel van with just enough conversion to serve as a "day van", loo, hob etc and a bed tolerable for the odd night or two away, but then it towing a small two berth caravan for proper "camping". Day van, something for regular "car" duty, but taking the loo and somewhere to stop and take a break, plus transport a decent bike, in our case.
A panel van conversion for two reasons:
The chances of leaking, damp etc are way reduced compared to a coach built unit
Whilst like a caravan the whole shakes about every mile it travels, with a panel van it has very likely been design to travel on roads, whereas the evidence is few caravan designers address that aspect of the units use! Add to that the miles on the road are likely to exceed those a caravan does so that ability to withstand travelling with any motorhome becomes more important.
Secondly, the "limited" size of panel van base motorhomes make visits to supermarkets and places of interest generally possible.
In respect to "auto" if that is a "desire", remember that until the last year or so Fiat and its derivatives only offered an "automated" manual" box as their Auto. IMO making one of the poorer takes in recent years on such beasts. Thankfully they now licence build the excellent "proper" ZF unit, but it's so young its likely to render such a motorhome too costly a used purchased.