I used to drive a 1985 Volkswagon Vanagon. It had a queen size bed in the back which was pretty cool when taking road trips. You could pull over and nap pretty easily without drawing too much attention to the vehicle. The downsides to the vehicle was the engine was in the back and under the back where the bed unfolded. Even though it had a decent seal and screws to compress the seal to the engine hatch, it just plane got hot back there. There was a really weak air conditioner and the upholstry inside that thing had a ton of static. You would scoot across the seat and instantly have your hair stand up. The van was underpowered, but I still enjoyed taking it on a road trip through Virginia all the way to Maine and back.
The only other van I've owned is our Honda Odyssey. It's got a third row that will fold down and stow. You can remove the second row seats and the back of the van is 4'X8'....which is bigger than most truck beds. It's hard to beat the configuration of a van because they have lower clearance than an SUV and as a result, have more interior room for storage or seating. Ours is a special edition with a built-in wet/dry vac, DVD, and powered sliding doors on both sides. You can do without the vac, but having a DVD and power sliding doors on both sides is mandatory these days. Speaking of doors...sliding doors allow you to load kids and other things a lot more easily to the van than traditional car doors. If you had a cake business or anything where you needed to load/unload more easily, a van is the way to go. I think Ford Transit may be the most configurable these days if you don't go with a Dodge Sprinter.
Last year, we rented a car from National and the kids picked out a Chrysler Pacifica. I thought it'd be junky, but we really enjoyed the drive we took from Miami to Orlando in that thing. It cruised really well, the seats were comfortable enough that the family slept, and the technology included was spot on. I was able to link my android phone using Google maps and it's making me consider getting a Chrysler based on how well they designed it to work. Unfortunately, many car companies screw up those interfaces. My wife and I were joking for months that were were going to trade in our van and get one....of course, we don't want a car payment and we know how those vans and brand depreciate.
Vans have a purpose and as long as you don't overpay for one, they can be a good value. You should expect them to depreciate faster than an SUV and some brands lose value way faster than others. Do market research and expect that most used vans get abused by kids. If you're embarrassed about vans and think they're stupid, then don't buy them. They're a niche market, but work great for road trips and car seats.