I wonder how much the rpi foundation would need to sell a pi if it included 32gb of storage. I would gladly pay not to feel like I'm playing roulette with my microsd.
It's pretty simple to do, as long as your USB drive is quick to come online.
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.
Sure. I'm not aware of any ARM based SOC boards with that 32GB of storage though (not saying there aren't any, just saying I've got 1st hand experience with that Udoo board and RPis...)
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...