There are some fun weird vans. I've always loved the Toyota HiAce, Mitsubishi Delica, and other strange Japanese minvans with weird features like built in karaoke machines, beverage coolers, tiny diesel engines, and real truck 4x4 systems. Also love the old VW vanagons.
They used to run (tongue in cheek) ads for the Boxster with the slogan "The more kids you have, the more practical it becomes" and that it fits "Two child seats. Up front." There's some truth to that- if you have a large family you will likely have multiple cars, it can still make sense for one of them to just take two people for 1 on 1 activities.
When I was in Ireland for work, I saw that a huge fraction of the farmers use MKIV TDIs for their farm work vehicles- they're all over the place pulling huge trailers full of livestock and hay, and still using half the fuel of most cars that are unloaded.
At a certain level of utility/space, cars just stop being that fun. Well, until you get to the vans, those are fun in their own weird way.