For TV tuners, try not to get a hybrid tuner. A hybrid tuner can switch between QAM/ATSC and NTSC, but not tune into them at the same time. NTSC is pretty much dead with the digital transition, though it can pick up basic cable in some areas. Instead, look for dual tuners which can record two digital QAM or ATSC broadcasts at the same time because there are two physical tuners on the card. The HVR-2250 is an excellent choice for a dual tuner.
Recording premium cable or satellite... well that's a lot more involved and would probably require a whole new thread.
Great thanks. By regular use, I mean maybe he will play the old starcraft but nothing like heavy gaming. He wants to have it double as a tv. His Price range is right around $500 and this is what that setup comes out to. I will definitely switch to the GA-785GMT-USB3 motherboard.
The processor does not seem that old and it is AM3. It seems to get solid reviews on newegg, should I get something faster?