I can weigh in with my small experience with their hardware. Back in the day we used quite a lot of their hardware for VPN-clients, firewalls and things like that in small-ish offices on work and I've been running my router for 5(ish) years without any hiccups with 1 spf port and 8x1Gbps copper and a 1/1Gbps upstream (trough spf).
I still have a bunch of old hardware gathering dust in the bin from when we ran them at the office (around 2010-2014, give or take a few years) and all of them still work. Granted, an old 100Mbps router isn't that useful today, but I still occasionally use them on my homelab for testing/verification of my ideas.
My current home office goes around 30C in the summer but that hasn't been an issue at all. And their pricing is pretty decent. The unit I have isn't available anymore, but vendor claimed that it can push up to 7,5Gbps trough and the price was something around 120€.
That being said, I don't have that much experience with them (only a handful of models and none of them was pushed too hard), but personally I'd pick anything from mikrotik over zyxel/d-link/tp-link.
I haven't ran any Pi with hard drives, but I don't see any reason why it wouldn't work with software raid on linux.