Currently I have 2 RP3s. Both running LibreElec & Kodi. One is just for viewing films stored on a 6TB USB drive and the other has TVHeadend and a TVHat. The pair ran really well until I installed a laptop cooling fan which needed me to move the RPis. Ultimately I trace the trouble I was having with recording on the sensitivity of the connection to the TVHat PCB - the smallest nudge can cause signal loss which requires much messing before recording again works.
I've found this (DVB-T2 USB Devices - LinuxTVWiki) but its 6 years old and I know the Hauppauge line will work with RPi just wondering if there are any others that people would recommend.