i went with the Compro E900F - full hardware decode, pcie 1x, dual hybrid (2x digital/hd channels + 2 analog signals at once) - windows update for vista and windows 7 installs them and works 100%, best tuners i have ever used, very expensive but hell they dont break or fail, and there pcie so no upgrading for a new system later etc
may be some better options out there now but like i can vouch for these suckers - briliant. I own two of them to be able to record 4 hd channels at once.
Software - your best off using Windows 7's media centre - nothing better out there, simple and perfect.
Downside - you need the software installed to use the remote - i dont use em anyhow, less crap installed to my system.