This is what we use, a Mitsubishi Delica 4WD with turbo diesel. There are two singles, a tandem and a bunch of holiday gear inside and the surf skis on top. It's serving us quite well...
There is a longer wheelbase version that might make shoehorning the tandem in a bit easier, but that would mean selling and buying again, and we don't intend to do that for a while.
We tend to camp with tents rather than sleeping in the vehicle. It's a security thing -- the bikes sleep in the vehicle under lock and key after Machka's bike was stolen two Easters ago.