I’m just going to wave the MythTv flag and wave it around a little.

Self-built box which is under clocked to run cool with a passive CPU cooler so it’s quiet

A few Hauppage TV tuner cards to record programs and then lots of torrents stored locally as I want to download / stream once.

No issues for years, decent TV UI for TV, films and music… and it just works.

It’s just not in vogue at the moment.