I am planning to use a USB digital tuner that will allow OTA local HD content to come into my MCE, that along with my other Satellite input should allow for a fairly nice setup.
With two TV tuners, you can:
Watch live TV on one channel and record a show on a different channel
Record two different TV shows that are on two different channels at the same time
Watch a show that you have previously recorded while two shows are recording at the same time, on two different channels
Don't give up yet, and if this will work for you I can explain the setup if it works.