Consider a Honda Acty - they even have models with a dumping bed.

These are quite expensive for what you get and are slooooooow. It's fine if you want an expensive, quirky neighborhood runabout, but you'll be made very aware that this is a product not at all designed for the US market (there's a good reason most examples do ~1000 miles a year). The ACTYs I found online were in the $7-20k range, for a ~30 year old model - more for a nice van.

The best used work truck is actually a van. They lack the coolness factor of trucks, but are far more versatile. You can pick up a <10 year old Transit with under 100k miles for like 10-15k. That price point will get you a >10 year old F150 in the 100-150k mile range.

Plus, there are good options if you want something smaller can car-based, like NV2000s and Transit connects. Which don't really exist for trucks outside of newer (maverick) or niche (Ridgeline) options.

Bonus points, a nice Transit is a great daily driver too.

Harsh did a tipper conversion for the Daihatsu Hijet, which had an 850cc triple with a lot more poke than the Acty's 660cc twin, and had a "true 4WD" variant.

In the UK, Truck and Driver Magazine featured one so equipped in a head-to-head AWD tipper test (AWD in the sense of all wheels driven regardless of number of axles, not Subaru AWD/Audi Quattro type AWD), alongside a variety of extremely large trucks. Proper trucks, not F150s, we're talking 18-tonne Scanias and stuff here.

Everyone wanted one of the little Hijets to take home.