DesignTechnica has a review of the Hauppauge WinTV-PVR-250. It's designed for people who want to integrate a Windows-based PVR into their Media Center PCs. One key benefit is the onboard MPEG encoder, which takes that workload off your main CPU. You would still need Snapstream or another front-end to use with the Happauge card. They conclude that:
Hauppauge’s WinTV-PVR-250 TV tuner and capture card is the product of choice for HTPC enthusiasts and Windows Media Center system builders, and for good reason. There certainly are lower-priced solutions available, but the PVR-250 has quite an advantage over them with its hardware based MPEG encoder, saving valuable processor performance for other tasks.Hauppauge WinTV-PVR-250 Review - Designtechnica Reviews
Onboard analog connectors allow you to not only watch, record and pause TV, but they allow you to record from other sources such as VCRs and analog video cameras.