In general terms I think that very small, very cheap hosts can use secondhand hardware, think DDR3/4 where RAM is still affordable. The 'Great' deals you see are mostly that. There are still $6/month for 2core/4GB VPS on EPYC if you need good performance (e.g example via https://serversearcher.com) but those types are unlikely to get any cheaper, for sure.