The first thing I tried was Virtual Server 2005R2 running on top of Windows 7. This appears to be a very good solution because it allows a single machine to act as a PVR server, a HTPC front end, and a backup server.
I installed Windows 7 x64 on my secondary pc with my TV tuner installed. Since the plan was to attach this computer to the TV for everyone to use, I wanted to keep the host os locked down. I created a passworded user account to act as the administrator and an open account to be used soley for HTPC duties. You can follow this guide to learn how to set up a Windows 7 user account to auto-login upon boot.