You can get this to work well if the cable signal to your home is decent. You may need to use something like a Motorola amp to boost the signal. I personally have had my share of adventures with the Ceton but it works well enough now that i am running the Ceton 99.9 percent of the time, My Tivo is just doing backup duty and will likely get mothballed soon. I don't really think that using the Ceton in a full fledged HTPC is the way to go af first.Test, Test, Test!.
I run mine Ceton host 24x7 and run no other apps on it. A full suite of HTPC apps is there but I don't use them. I would put the Ceton at the most advantageous spot cable drop wise and then use either and extender or a dedicated client PC ro run a networked tuner for each display.
My brother finally after fighting bad cable drops and a bad Ceton card has two Cetons running in a headless i3 Win 7 box in his server room and uses simple intel Pentium or i3 SB mini-itx clients or extenders through out his house. To say getting it working right was vodoo would be an understatement. I would not go through what he did. I would have thrown the whole mess off the second floor balcony. But now that is sorted a year later he is very pleased with its performance.
The newer Ceton cards are just plain better hardware, the newest firmware is better, having Comcast replace all the coax on the street priceless. Without the Motorola amp though forget about it. The problem is YMMV. Lots of people have this working robustly. Depending on the provider and the wire you may have great succerss with minimal effort, on the other hand....
I don't even run the Aero interface on Ceton host box, a vanilla SB i3. I do run2 dual HD Homerun ATSC tuners. The Tivo HD is unqquestionably a more robust signal captuire device then the Ceton. Still the Ceton I have gets the job done. If WAF is critical you could be held to the Cable STB or Tivo standard of availability. Again though, you never know about your individual signal. If you have trouble with the providers equipment capturing and locking to signals then don't expect Cetons or HD Primes to do it better because they don't
My final thought is that things are muich more likely to go really well today than a year ago.
Mits WD-92840 92" DLP - Lumagen Radiance XS, Martin Logan Motion 40s, Ascend Sierra 2s
Older 58" Panny Plasma -DVDO DUO, JBL Studio 530
Pioneer AJs, PSB Images, Usher S520, JBL HLS-610, Definitive SM45, MusicHall Marimba