Yes, no, sorta.
If you only care about channels that your cable provider leaves in the clear, either as analog NTSC or unencrypted QAM (ClearQAM), then any old HTPC with a tuner card will do.
If you want channels that are encrypted, you will need to buy a whole PC with a CableCARD tuner from one of the PC manufacturers such as HP, and get a CableCARD from your cable provider. Currently this is the only way you can get CableCARD capability on your PC.
If you only care about channels that your cable provider leaves in the clear, either as analog NTSC or unencrypted QAM (ClearQAM), then any old HTPC with a tuner card will do.
If you want channels that are encrypted, you will need to buy a whole PC with a CableCARD tuner from one of the PC manufacturers such as HP, and get a CableCARD from your cable provider. Currently this is the only way you can get CableCARD capability on your PC.