RPi4 is excelently supported, but DVB is an icky topic regardless of hardware. The general recommendation is to separate tuners from the playback device so you can run whatever OS and hacked version of drivers and firmware that works reliably .. with playback on something simple that you can OS bump whenever LE puts out a new release. The moment you put both functions on the same device you can have a reliable player or DVB that works; they are generally mutually exclusive and you have to chose one.
That means you could revert to a legacy image, e.g. CE or dtech's LE 9.2.8 one for the TVH side. RPi4 is a nice playback device if you can get your hands on one.
Yes - though the single-tuner DVB-T/T2 TV Hat on the Pi 4B is almost an integrated tuner and is available for £6.30 on Amazon UK at the moment. (In the UK this will allow you to record any or all HD services simultaneously - as they are all on the same frequency here in the PSB3 mux - though I think the SPI interface used does struggle to stream the full 40Mbs of a PSB Mux so you may not be able to record ALL channels simultaneously...). As it's a Raspberry Pi product, driver support on Pi OSs is reasonably good I think, and the Pi team are good at mainlining their driver support AIUI.
You can get cases that are designed for the Pi 4B and the TV Hat too.
However as chewitt says - it's usually better to separate your DVB/ATSC tuner and TV Headend backend from your Kodi playback solution, as it avoids your Kodi playback solution (like LibreElec) needing specific driver support.
You can also look at HD HomeRun networked DVB-T/T2 tuners (now available again - and available in 2 and 4 tuner flavours - along with ATSC variants in North America) or SAT>IP if you are looking for DVB-S/S2 functionality. These move tuner support to a networked device, meaning you can run TV Headend on Kodi platforms (should you wish) as the driver support is removed from the OS running Kodi, or you can run TV Headend on things like NAS/Unraid/ESXi VM boxes, or a small Pi server that just sits on the network with a hard drive for recording.
I run HDHomeRuns and SAT>IP mainly these days - with just a couple of USB DVB tuners kicking around for backups, use out and about etc.