I need to get a drive to fit my tiny pc. How long are we talking? If it's every 3-5 years, I don't mind using an SSD.
Hard to say. I've had dozens of ssds and hdds fail, some on the low side, some on the mid side, but I've never had an SSD last longer than expected (above it's average write duration). I just replace all drives after about 3-4 years of 24/7 usage.
I suppose that 24/7 block writing is actually hard on an SSD. Hmmmm.... It might still be worth it for me to use an SSD for non-speed reasons, though.
it's not that bad unless you're re-syncing from scratch all the time, a node isn't going to do 24/7 block writing, it's the initial sync that's heavy in writing, and after that there's a new block approximately every 10 minutes which is pretty much negligible in write traffic compared to normal computer usage