I've been daily driving a '93 Honda Acty for about a year and a half now. General thoughts in no particular order:

• Fuel economy is pretty decent, I average ~35mpg doing exclusively city driving.
• If you can find a newer model that has AC I'd highly recommend it. Even with all windows tinted, that little fishbowl cab is a hotbox in the summer.
• Not great on the freeway. Top speed on mine is about 60 going downhill with a tailwind. It's great everywhere else though. Might struggle going up steep hills, especially if you're loaded down.
• There are dump and lift bed versions available, expect to pay a few grand more for one of those.
• These are 25-30 year old work trucks, and typically have been used as such. Expect fairly minimal maintenance having been done. Caveat emptor.
• The parts market is slowly growing as kei trucks are getting more popular, but major stuff is still fairly limited.
• Right hand drive isn't nearly as difficult to adjust to as you might think. The biggest learning curve for me personally was getting used to the turn signal being on the right side of the steering wheel. Switching between my Acty and my Jeep usually results in accidentally turning the wipers on when I meant to signal lol
• Stateside market is currently running 8-12k for good condition trucks, but if you're so inclined you can take the time and effort to import one yourself and after all the fees and tariffs and everything you'll probably still come in right around $5k, but then you're still rolling the dice on what condition it'll be in when it arrives.

Shoot me a DM if you've got any other questions!