Specifically I'm using the OrangePi Zero 2W and the Banana Pi M4 Zero (both are Pi Zero form factor), but I figure if it works in a Raspberry Pi it should work in these. Wondering if they're worth the cost, if they work at all, and/or if it's just asking for trouble.
The project I'm working on requires a good bit of storage. It's essentially an "internet in a box" device that has a portable selection of media (Wikipedia dump, music, TV shows, movies, and books) as well as web-based software to view them (Kiwix, MPD+Snapcast, Jellyfin, Calibre-Web, etc) as well as some other utilities (PiHole for DNS/DHCP/ad blocking, Searx-NG, VPN clients and routing, etc).
The OrangePi is currently the working prototype, and it has a 512 GB SD card and a 512GB USB-connected NVMe. Due to a quirky wifi chip, it requires a separate USB wifi adapter to do hotspot. Because of this, it kind of sprawls and isn't very portable without disassembly.
The Banana Pi has a better wifi chip and can do hotspot internally. So to keep my portable server keychain sized, I'd like to outfit it with either a 1 TB or 1.5 TB SD card for its media store rather than attaching a USB->NVMe enclosure. This one also has eMMC for the system, so it wouldn't be booting from or writing logs, etc to the SD card. Most of the data/media on the SD card would be WORM (write once, read many) but would be updated/refeshed periodically.
Would a large 1 or 1.5 TB SD card (Samsung or Sandisk, depending on price) be a waste of money or be a cause of issues?
Yep. My house is block and brick and just soaks up heat all day and very slowly releases it at night. Unless there's a 20-30 degree (F) difference, it just doesn't cool down at all. It's even worse when the night time temps don't drop significantly until just an hour or two before dawn when it starts heating back up again.
That's great in the winter since a sunny day can "store" heat for the night, but it's miserable in the summer and you basically just have to pump it out with A/C.