Japan and the rest of the world figured this out decades ago. They're called kei trucks. You can buy pre-2000 imported ones in the US from like $5-15k depending on the miles/condition/year/transmission. I have a 1990 Suzuki Carry that is solely used for trips to Home Depot and picking up random furniture from FB Marketplace that I got for $6k.
And it's great that the US is (seemingly, somewhat) catching up.