In my area it is about split 50/50 between grungy old sedans loaded to the roof, and plain white Transit Connect vans. The latter seems to be increasing in popularity.
Here: Amazon Logistics by day, Uber by night. Just a guy in a normal Toyota Prius...
Yeah for my area it's about 70% UHaul, 30% shady looking unmarked van. Yesterday I saw for the first time a van that was actually one of those Amazon Prime vans they show in the photos on their website. It wasn't delivering to me, but I saw it driving in my area.
My last one (two days ago) was just a guy in an unmarked sedan.