You can use a relatively cheap Pi as a NAS (network-attached storage - there are ready-made solutions but expensive and don't get updates for nearly as long), and possibly add Kodi media server capabilities (useful for smart TVs). Check if that model supports a sufficiently fast disk interface (USB 3.0, SATA etc.) and Ethernet (100 Mb/s or better if 4K is required). Boot from an SD card and use a 2TB+ HDD (1TB could be enough if you barely store anything). Most disks from the past 10 years will be good enough to play 4K video from if no OS is running from them. Go for a lower-end one but not ridiculously cheap, and check that people aren’t frequently complaining about the model or product line.

I don't know which Pi models can smoothly play HD video without overheating, I don't own any. But those that can are likely a lot more expensive than old PCs you could use otherwise. I would just get a cheap one for a NAS and probably some other common network use cases (web server, Pihole etc.)