I have the ATI 650 Pro PCI express tuner. It works great except for the software that came with it, it sucks, so I use Beyond TV 4 for my software as I do not have Windows Media Center. As for over the air HD I do not know because in my rural area there are no over the air HD antennas. I"m not sure about he PIP either, it will depend on the software too, I think. I can not have it because I have analog cable, not digital.
Hope that helps.