If you don’t require ECC RAM a common setup these days is a Proxmox cluster set up on refurbished USFF PCs like the Lenovo m720. They sip power at idle.

My personal approach is separate archived storage from working storage and keep archive storage offline until I need it. Keeping hard drives spinning is costly.