It's hard to buy a bad system these days. Especially for non-gaming use, you'll almost never exceed the capabilities of an off-the-shelf computer.
For noise and reliability concerns more than anything, I like 3-year-old off-lease former-corporate Dell and Lenovo. The AK/Glock of the computer world. Refurbishers on ebay are fantastic, because their churn operations guarantee you won't get bloatware.
There's also a really nice sweetspot at 5 years when MACRS depreciation renders ex-enterprise gear essentially "free".
Your 1TB requirement is going to conflict with the absolute modern requirement of a SSD main drive. Buy a cheap external drive.
Spend the $50/year on Backblaze or similar service. It is worth it.
If you require support post-purchase, buy new from a big company and buy an extended warranty.