After the advice from a fellow HN reader [1] I bought a bunch of aMLC microSD cards from DigiKey. No S&H costs and it literally arrived 1,5 days later (from Springfield to The Netherlands) though I had to pay import tax. Needless to say, they've been rock stable. I'm using one in a Pi and one in a Dafang camera [2]. I still gotta replace the microSD cards in the remote Pi's though but I'll do it once they break (again).
a) eMMC which can use a tiny flash module of the same type flash as found in MLC SSDs, with flash controller chip for write wear leveling
or
b) M.2 NVME SSD interface such as can be found on 170x170mm mini-itx x86-64 motherboards for intel or amd single socket CPUs. And of course on larger motherboards as well.
c) the "traditional" SATA3 disk interface which can be used for a SATA3 interface SSD.
Due to the very limited write lifespan of microSD cards, even "industrial" ones, it's just a really bad idea reliability wise to use a microSD card for boot and OS storage on any sort of remote embedded system that does anything important.
The drive writes per day (DWPD) figure in GB for even a cheap $55 consumer grade MLC SSD is vastly higher than the amount of times you can write to a microsd card.
I have an RPi running on one of those tiny USB thumb drives that only protrude a few mm and it's running a data capture suite I wrote to monitor my internet connection which writes to a PostgreSQL database on the Pi.
This is a big jump up price-wise on the 'Pi, but it meets your "32gb of storage" requirement for $174:
https://shop.udoo.org/other/home/udoo-x86-advanced-plus.html
I was hopeful that NextThing would get there, their C.H.I.P board was nice (when you could actually get them to sell you any) and had 8GB on-board, but they went tits-up earlier this year. Hardware is hard...
I've started buying SanDisk's "High Endurance" microSD cards hoping it will mitigate any such issues in the future, but I haven't had time to get the NTP set up again... I really should have cloned the image.
I think the hardest part was finding a case with space for the GPS hat[0] with an open end for the coax connector. The hat sits a bit crooked because of something bulbous on top (condensator?).
[0]: https://store.uputronics.com/index.php?route=product/product...