Now my question is... all the new codecs (HVEC, 4:2:2, 4:4:4) are software correct? The signal is still DVB-S2 and thats what the 6922SE does so it will still get the signal and then its up to the software to decode the new codecs.
My understanding is that what you have said is essentially correct. All the card does is stream the channel or mux to something that can process it. Video codecs are the responsibility of whatever device and software plays that stream (or recording if you have made a recording). Depending on the capabilities of the device's GPU the video may be decoded in hardware or software. If software decoding is necessary then you need enough CPU power to handle it. Most newer desktops and laptops can decode the formats you've mentioned in real time (not sure about 4:4:4, have not encountered that one) but you may be nearly maxing out the CPU if the GPU can't handle it. Some lower end computers can't handle UHD formats and will start dropping frames or not show a picture at all.
Bonus questions: What is the best software for PCI tuner, free and paid?
Depends on if you prefer to use Windows or Linux. In Windows you have several choices, you might want to try MediaPortal or NextPVR or something like that. In Linux I'd try Tvheadend. I believe all of those are free but I may be wrong. The problem with using TBS cards under Linux is that they have their own drivers that are not integrated into the Linux kernel so every time there is a kernel update you need to recompile the drivers, and the problem with that is that lately they have made some changes in the Linux kernel that have caused failures to recompile. Tvheadend in my opinion is a pretty great program, but it doesn't actually play video, it just acts as a video streamer and a PVR so that you can use another program such as VLC or Kodi to play live or recorded TV (Tvheadend is the "backend", Kodi is the "frontend" - you typically only have one backend program running but you can have several frontends running on different devices). I believe MediaPortal has both backend and frontend functionality, but don't quote me on that.
Your old PC would probably make a great backend server, even if it doesn't have the requisite CPU/GPU power to play newer formats. If you are into Linux there was a blog that published several articles on using TBS cards with Linux a few years ago, I believe it was this one:
Free-To-Air America . I recall they had some specific tips about tweaking settings in Linux to make TBS cards work better, though I don't know if that information is still valid, and also IIRC some articles about Tvheadend and other topics you may be interested in IF you are a Linux user. There wasn't much there for Windows users IIRC.
I don't care all that much for Linux but it has one great attribute - it's free! So while there may be (probably are) several other good choices for Windows users, I haven't heard about them, because I'm a cheapskate that runs Linux on my media PC (Ubuntu Linux if you are curious). Both Tvheadend and Kodi will run under Ubuntu. But sometimes I feel like I barely know what I am doing.
However if you have no interest in recording anything for later viewing then you may be able to get by with simpler software that will just let you tune channels and watch them on your PC. If your old computer runs Windows Media Center I think it will let you do that, if not there are probably other programs that will give you that ability, but someone else will need to suggest them because I don't know about them.