Anandtech has some good articles on some of the popular frontends
Link
I've used SageTV and MCE 2005 (and various freeware frontends), both are excellent and feature excellent schedulers and multituner support. I prefer MCE 2005 due to its HD support, and the family like it as well.