Both share the same MLC NAND flash chips and very similar controllers to use them as usual storage (i.e a machine to read/write LBAs).
=>Don't globally expect better results from most consumer grade USB keys than uSD.
The only way to get something reliable would be to use industrial grade eUSB. But they are designed to be plugged directly on a PCB connector, not a usual external USB one & Raspberry don't exhibits a USB port signals on it's IO pins.
Industrial grade uSD exists, but they are hard to find.
All theses industrial grade devices are provided with a choice of underlying NAND technologies:
SLC: The single level old but best for lifetime (usually 100k erase cycles supported) for write intensive loads. But that may be 100€ for 8 GB... So more that 10x cost/bit increase!
MLC: Consummer grade multi-level (i.e. a cell is able to discriminate several charge loads using comparators, thus able to store several bits/cell. If you can check 3 levels, you can store 4 states thus 2 bits/cell) usually given for 3k erase cycles only (multiple level comparison => less margin and as charge tend to leak more and more with erase cycle count...). These are for read intensive only tasks, only difference with consumer grade products is in the controller firmware: Usually better wear leveling algorithms + better power loss tolerance.
pSLC: Probably the best bargain, it's MLC chips (to benefit from consumer grade chip volume price) used in SLC mode. Given for 30k erase cycles with a cost/bit "only" doubled.
These underlying technologies makes a difference, not the form factor.
A reseller willing to sell such well chosen devices (for instance Swissbit S46u pSLC based series) for home automation users would IMO be welcome.