My personal recommendation is buying a mini PC for your needs unless you absolutely want to build one.
Minisforum:
Bee-link:
For Linux and Fedora that would only endure minimal strain on your PC, you can literally buy almost anything and it will run fine. If you choose to get one of those mini PCs from companies linked above, it will last for a very very long time unless you somehow mistakenly physically damage it. And you can always upgrade components in those mini PCs too.
Edit: also you haven’t mentioned your budget but you can buy a decent mini PC for about $500 US or around that price that will last for close to a decade if not more - for your use case strictly at-least. But a lot of the computers the companies linked above are selling are close to $1000 than $500 so you are even more future proofed should you go with any one of them.