I would look at the HD HomeRun. It is designed to do what you are describing.
Keep in mind that with cable you will need to make sure your provider doesn't encrypt everything. The technical term is Clear QAM. PPV and Premium channels will be encrypted.
You could look at solutions that are M-OCUR (Cable Card) based.
What is your budget?
What is your OS and Media Center?