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.