> Modern US trucks are an absolute atrocity

This.

I'm living in EU, thinking about getting some pickup. Just want to try this kind of vehicle (and I would love to transport my motorcycle, building materials etc). But I want something small - it looks like almost non-existent market here (there are cars like older f150, s10, etc - but very, very limited offers). Everyone gets the big modern trucks, that are unusable in our tight spaces.

> I would love to transport my motorcycle, building materials etc

Just get a Renault Traffic or equivalent. I don't see any advantage pickup trucks would have against a white van when transporting anything.